Re: method_opt

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 25 Jun 2004 16:55:26 -0600
Message-Id: <6.1.0.6.2.20040625165132.02ce3d58@pop.centrexcc.com>

Just use the default ( 'for all columns size 1'). For non-partitioned tables

dbms_stats.gather_table_stats(null,'xxx',cascade=>true);

is equivalent to

analyze table xxx compute statistics

At 04:28 PM 6/25/2004, you wrote:
>I don't really understand method_opt usage for dbms_stats. If I issue a
>simple analyze table compute stats, what would be the clause to supply
>method opt to mimic the same sort of analysis as that analyze command?
>I'm not concerned with histogram generation at this point in this test.
>Thanks
>--
>..
>David
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------

regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jun 25 2004 - 17:52:25 CDT