RE: Histograms

From: David Kurtz <info2_at_go-faster.co.uk>
Date: Tue, 16 Aug 2005 13:09:55 +0100
Message-ID: <CKEAJBMGFEOCDBFILPJDAEBIGKAA.info2@go-faster.co.uk>

This artcle seems to say: 'I heard about this from some people, it sounds like a good idea but I haven't tried it for myself'. Not advice in which I would place implicit trust.

Personally, I use histograms when I can demonstrate that they are beneficial. They take extra adminstration, extra time to collect, and add extra parse time. They have to pay for that with improved performance.

regards

David Kurtz
Go-Faster Consultancy Ltd.

tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk

mailto:david.kurtz_at_go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com Next Go-Faster Seminar: PeopleSoft for the DBA, London UK, October PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Charlotte Hammond
> Sent: 16 August 2005 12:34
> To: ORACLE-L
> Subject: Histograms
>
>
> 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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 16 2005 - 07:12:03 CDT