Re: Table Analysis Info

If you want to know whether tables are being analyzed run the following:

SELECT table_name
FROM user_tables
WHERE num_rows IS NULL;

If any rows are returned analysis has not been done since whenever the oldest of those tables was created.

But as a DBA I think you are taking the wrong approach: Go ask!

Daniel Morgan

R Chin wrote:

> I don't want to ask the DBA about our table analysis practice
> I'd like to find that out myself...
>
> How does one find that out ? Querying....
>
> USER_TAB_COL_STATISTICS
>
> That seems to be a big table(view), I issued the SQL 2 mins ago, and it's
> still going...is there a faster way ?
>
> Thanks
>
> R Chin
Received on Tue Mar 12 2002 - 10:01:16 CST