Re: Periodic Stats Collection -- CBO Stats Myth?

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: k.sriramkumar@xxxxxxxxx
  • Date: Fri, 03 Oct 2008 14:00:31 -0600

gather_table_stats with an estimate_percent of less than 100 uses the sample option of the from clause, e.g. select ... from tbl sample(10) and determine the min and max values for columns based on the values in the rows returned by the sample. 


At 12:50 PM 10/3/2008, Sriram Kumar wrote:

Hi Tim,

Thanks for your inputs. Appriciate your inputs.
I had one more question. If we are performing sampling ( lets say 10 percent), how does the stats gatherer estimate the high value especially for date columns?. 

Best Regards

Sriram Kumar



Regards

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2008