Re: ORACLE automatic update statistics better??
From: Greg Rahn <greg_at_structureddata.org>
Date: Fri, 13 Aug 2010 09:55:21 -0700
Message-ID: <AANLkTimZZY5sVrg3X5Uk_H51T+U2=iCGYcZ=zs+6kZQt_at_mail.gmail.com>
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/
Date: Fri, 13 Aug 2010 09:55:21 -0700
Message-ID: <AANLkTimZZY5sVrg3X5Uk_H51T+U2=iCGYcZ=zs+6kZQt_at_mail.gmail.com>
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