Re: Analyze

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:20:44 CST