How to detect rows_num variation?
-
I'm running on a 10.2.0.4 RAC database, and I need to detect if a table has a 20% variation in the amount of rows, I mean, if the table has increased or decreased in the number of rows by DML transactions, in order to decide if run or not statistics.
-
Do you know a query or a way to achive that?
-
Thanks in advance.