stats on tables - analyze for all indexed columns
- From: "Fedock, John (KAM.RHQ)" <John.Fedock@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Mar 2004 14:27:05 -0500
Looking for some advice on gathering stats on my tables.
I analyze estimate statistics on most tables and analyze table for all indexed
columns on a few others (also known as Histograms). I then have a job that
goes through and copies num_rows, blocks, etc and stores this in another table.
I'm sure most shops have similar jobs set up like this.
I have noticed that when doing the histograms, no data is gathered at the table
level, only at the index level. I am reluctant to also include the table, as
things are running great right now. Any ideas .... or any harm in gathering
table stats AND histogram info.
We are using the CBO and running v 8.1.7.4 on HP-UX.
TIA.
John
John Fedock
"K" Line America, Inc.
www.kline.com
* john.fedock@xxxxxxxxxxxx
Other related posts:
