General information about stats


General information about stats


1.I would like to ask if there is any table in Teradata , like tab_modification in Oracle where we can see the tables which have more than 10% of dml transactions?

If not , which is the recommended way to collect stats ,  by date & dml transactions only? this is really heavy...

2.How can we identify the unused stats of a table?

Thank you very much.