Re: stats on tables - analyze for all indexed columns
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 4 Mar 2004 16:14:31 -0500
Analyze table ....for all indexed columns collects only histograms on indexed
columns.
Analyze table ... for all skewed columns collests only histograms for columns
that oracle deems skewed.
analyze table .. for table collects statistics for table itself. When you use
DBMS_STATS.GATHER....
then "FOR TABLE" is implied.
On 03/04/2004 02:27:05 PM, "Fedock, John (KAM.RHQ)" wrote:
> 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
>
>
>
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
