Re: hmmm....

From: joel garry <>
Date: Mon, 28 Feb 2011 13:21:46 -0800 (PST)
Message-ID: <>

On Feb 28, 12:46 pm, Noons <> wrote:
> How is it that dbms_stats accepts "estimate_percent" as a percentage
> of the rows to sample, when it obviously doesn't know what 100% is
> until it's done a full sample?
> Something's amiss and I reckon it's a thing called logic...

Season as with all MOS, but see Why or When does Dbms_stats.Auto_sample_size sample all rows [ID 343849.1]

"...but then dbms_stats will take an accurate row count by using SELECT COUNT(*) from the table and index" shows an interesting test.


-- is bogus.
Received on Mon Feb 28 2011 - 15:21:46 CST

Original text of this message