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_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004