Re: AUTO_SAMPLE_SIZE is every row
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 26 Jan 2018 18:14:10 -0500
On 01/17/2018 12:48 PM, Neil Chandler wrote:
"estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE" is the default
setting from Oracle 11G and it perform a full table scan to determine
the table statistics very accurately.
And for some tables, full table scan is unacceptable, regardless of the
accuracy.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
Other related posts: