Re: Histogram ENDPOINT_ACTUAL_VALUE empty using DBMS_STATS

I don't get ENDPOINT_ACTUAL_VALUEs with either gather_table_stats or 
analyze on Oracle 9.2.0.4 (or 8.1.7.4) on W2K. Can't test on Linux at the 
moment. Maybe it's an XP thing.

At 06:19 PM 9/2/2004, you wrote:
>I was doing some histogram testing and came across something I couldn't
>explain nor could I find anything on Metalink about it and was hoping
>someone could assist.
>
>Here are the specifics:
>9.2.0.4 on Windows XP
>table with 1 million rows
>county column (varchar2(30)) has 11 distinct values
>data values in the column are distributed as follows:
>COUNTY                 COUNT(*)
>-------------------- ----------
>ANDERSON                  50000
>BROWN                     25000
>CANNON                    25000
>DAVIDSON                  50000
>FAYETTE                   50000
>GORDON                    25000
>HARRISON                  25000
>LANCOME                   25000
>MULTNOMAH                 25000
>SMITH                    100000
>WASHINGTON               600000
>

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com 

---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Other related posts: