Re: How to analyze a odd column distribution

From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
To: aleon68@xxxxxxxxx
Date: Wed, 19 Jan 2005 12:08:33 -0700

If you have a histogram then the optimizer should correctly recognize 
the historic outliers.

How did you create the histogram, what does dba_histograms contain for 
that column and what are the problem queries like?

BTW I see a Y3K problem looming.

Alfonso León wrote:

> Hello everyone:
> 
> Now there
> are about 5 million records and half of them are historic so there are
> 2.5 million records with 31-dec-2999 and it is confusing the
> optimizer.
> 

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

References:

How to analyze a odd column distribution
From: Alfonso León

Re: How to analyze a odd column distribution

Other related posts: