Re: AUTO_SAMPLE_SIZE is every row
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 26 Jan 2018 18:14:10 -0500
Message-ID: <b24f0ecb-55cf-27b4-0267-00dafeceb6ca_at_gmail.com>
Date: Fri, 26 Jan 2018 18:14:10 -0500
Message-ID: <b24f0ecb-55cf-27b4-0267-00dafeceb6ca_at_gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 27 2018 - 00:14:10 CET