Starting in 11g (11.1.0.6) http://structureddata.org/2007/09/17/oracle-11g-enhancements-to-dbms_stats/ On Thu, Aug 4, 2011 at 7:17 AM, Robert Freeman <robertgfreeman@xxxxxxxxx>wrote: > The correct value is C - You should use the Oracle default value. Starting > in 11.2.0.2 (I think) Oracle actually does a full scan of the table. It has > removed the need for a sort as a part of the scan, therefore the process is > much faster and you get much more accurate statistics. So, if you have the > sample size set, you should unset it...... > -- Regards, Greg Rahn http://structureddata.org