| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: stats on tables - analyze for all indexed columns
I agree .... But when my boss looks at the stats tables and see some tables have no data (rows, blocks, etc), it messes up his reporting and I have to explain again and again why there is no data there. Maybe it will go away if I stay under the radar.
Thanks all,
John
-----Original Message-----
From: Koivu, Lisa [mailto:Lisa.Koivu_at_Cendant-TRG.com]
Sent: Thursday, March 04, 2004 3:05 PM
To: oracle-l_at_freelists.org
Subject: RE: stats on tables - analyze for all indexed columns
Dear John.... IF IT WORKS, DON'T FIX IT
At least not in production.
Lisa
-----Original Message-----
From: Fedock, John (KAM.RHQ) [mailto:John.Fedock_at_us.kline.com]
Sent: Thursday, March 04, 2004 2:27 PM
To: oracle-l_at_freelists.org
Subject: stats on tables - analyze for all indexed columns
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_at_us.kline.com
"The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Mar 04 2004 - 16:13:38 CST
 |
 |