Re: ORACLE automatic update statistics better??
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- 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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
