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 - //freelists.org/archives/oracle-l/09-2004