Oracle table statistics

[#1]

Dear All Members,

Is there any way where we can check whether current statistics in table are outdated in oracle? In OTN i found using view "DBA_TAB_MODIFICATIONS" we can gather timestamps of statistics

But can we use this to compare the quality of statistics in DB tables?

Regards,

Shanaka.

[Former Member]

Statistics do not get outdated, you only need to collect new statistics, when the data changes significantly. Thus the trigger is not the last_analyzed field.

588668 - FAQ: Database statistics

Cheers Michael