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.