Re: ORACLE automatic update statistics better??
Date: Fri, 13 Aug 2010 09:55:21 -0700
I would strongly discourage the use of
method_opt=> 'FOR ALL INDEXED COLUMNS SIZE 1' unless you really know what you are doing and why you are doing it. More here: http://structureddata.org/2008/10/14/dbms_stats-method_opt-and-for-all-indexed-columns/
On Fri, Aug 13, 2010 at 8:08 AM, dba1 mcc <mccdba1_at_yahoo.com> wrote:
> we have ORACLE 10GR2 on LINUX server. Our consultant don't allow us "manually" to run "update statistics". Consultant say ORACLE 10GR2 automatic update statistics algorithm better than manually command.
> The SQL command we used to manually run is:
> execute DBMS_STATS.GATHER_SCHEMA_STATS (ownname=> UPPER('&ID'), estimate_percent=> dbms_stats.auto_sample_size, method_opt=> 'FO
> R ALL INDEXED COLUMNS SIZE 1', DEGREE=> DBMS_STATS.DEFAULT_DEGREE, cascade=>TRUE)
> I would like listen your opinion.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 13 2010 - 11:55:21 CDT