Toad World® Forums

Table Analyze


#1

Is it possible to the date/time of the last time a table was analyzed? Either displayed when you open the object an/or when you go to analyze it.

Thanks.
-Charlie


#2

Hi
Just for note, Charile it’s better to use dbm_Stats utility to analyze your objects, there is more settings of gathering statistics,then you can manage your statistics,recover and lock them on objects. But I agree it’t would be nice to have time of last analyzying.

Regards Piter.


#3

Thanks. Then maye we can ask the development team to look into using dbms_stats when SqlNav does the analyze, and have those other options available?

Thanks.
-Charlie


#4

Thanks Charlie & Piter for this enhancement request & suggestion .

We will raise a request on your behalf and will take it on board for the next release.

Thanks and regards,
Bruce