Re: Table Analysis Info

From: damorgan <damorgan_at_exesolutions.com>
Date: Tue, 12 Mar 2002 16:39:46 GMT
Message-ID: <3C8E2F53.421D9E13@exesolutions.com>

Maybe. But a DBA who is being end-run can be a very unpleasant person.

Ask me how I know. <g>

Daniel Morgan

Knut Talman wrote:

> > 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.
>
> What about querying LAST_ANALYZED from user_tables ?
>
> > But as a DBA I think you are taking the wrong approach: Go ask!
>
> Maybe his/her DBA is very busy... Or he/she has some problems with him...
>
> Regards,
>
> Knut
Received on Tue Mar 12 2002 - 10:39:46 CST