Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Histograms

Re: Histograms

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 16 Aug 2005 07:16:47 -0600
Message-ID: <4301E73F.9030604@centrexcc.com>


Like David and Yasin, I am against the "broad brush" method and use histograms only in specific cases with demonstrated benefits. I don't have a testcase, but I have a documented case at a client where they changed their week(end)ly statistics gathreing from the default "for all columns size 1" to "for all indexed columns size skewonly" and had the bottom fall out of a batch job that usually took 1.5 minutes because one frequently executes sql (1000s of times) went from .01 elapsed to around 80 seconds elapsed.
So be careful whenever you change your statistics gathering strategy. And that is not limited to histograms.

Charlotte Hammond wrote:

> Hi All,
>
> Can I poll the list on their views on the use of
> histograms? I've previously been quite conservative,
> only gathering them when we've had a specific case of
> bad CBO performance due to skewed data. However I was
> interested in this article mentioning a "broad brush"
> approach to histogram gathering:
>
> http://www.dba-oracle.com/oracle_tips_all_columns_histograms.htm
>
> Any thoughts to share?
>
> Thank you
> Charlotte
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 16 2005 - 08:18:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US