Re: Analyze

From: Rocr <rolland.cright_at_pwgsc.gc.ca>
Date: Thu, 25 Jan 2001 15:37:07 -0500
Message-ID: <94q2pd$kek1@shark.ncr.pwgsc.gc.ca>

You read my mind. Groovy...

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:t712hbd4s5b653_at_beta-news.demon.nl...
> The datadictionary tables like sys.tab$ and sys.ind$.
> You can use the dbms_utility.analyze_schema('<schemaname>','DELETE') to
> delete the statistics, so stay away from those tables. You don't see
> anything more by querying from tab$ instead of user_tables.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "Rocr" <rolland.cright_at_pwgsc.gc.ca> wrote in message
> news:94puik$kpd1_at_shark.ncr.pwgsc.gc.ca...
> > Can anyone tell me what table(s) are populated when the analyze command
is
> > executed.
> >
> > Thanks in Advance
> > rocr
> >
> >
>
>
Received on Thu Jan 25 2001 - 14:37:07 CST