Re: Performance of DBMS_STATS vs ANALYZE

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Fri, 21 May 2004 04:30:17 -0700 (PDT)
Message-ID: <20040521113017.14758.qmail@web20728.mail.yahoo.com>

Hi Wolfgang,

• Wolfgang Breitling wrote: >

Yes, they are vital. IMO if you are running dbms_stats (or analyze) you MUST gather the basic data for the columns - num_distinct, nulls, min, max, avg_col_len - which is what the 1-bucket histogram is. Thanks for that - I think I'll keep the histograms then! :-)  

Point taken about taking care over if/when to re-gather.  

Thanks
- Charlotte                 

---

Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

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 Fri May 21 2004 - 06:27:10 CDT