Re: method_opt
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 25 Jun 2004 16:55:26 -0600
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@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
