> -----Original Message-----
> From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
>
> Someone asked me where the results of analying tables and
> indexes goes. Can
> anyone tell me what table(s) holds the statistics generated.
I think this is a complete answer. If I've forgotten anything, please let me know, since this is the list I give out to people.
Sys views: Tables
dba_tables sys.tab$
dba_tab_columns sys.hist_head$
dba_tab_col_statistics
dba_tab_histograms sys.hist_head$
sys.histgrm$
dba_tab_partitions sys.tabpart$
sys.tabcompart$
dba_tab_subpartitions sys.tabsubpart$
dba_indexes sys.ind$
dba_ind_partitions sys.indpart$
sys.indcompart$
dba_ind_subpartitions sys.indsubpart$
Jacques R. Kilchoër
x8816>
