Re: Periodic Stats Collection -- CBO Stats Myth?
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:
>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?.
Centrex Consulting Corporation