RE: results of analyze

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 29 Aug 2001 12:06:07 -0700
Message-ID: <F001.0037BD6C.20010829120034@fatcity.com>

> -----Original Message-----
> From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
>
> 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> Received on Wed Aug 29 2001 - 14:06:07 CDT