Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: analyze vs dbms_stats

RE: analyze vs dbms_stats

From: David <thump_at_cosmiccooler.org>
Date: Fri, 25 Jun 2004 10:07:23 -0700 (PDT)
Message-ID: <3968.64.37.153.21.1088183243.squirrel@www.cosmiccooler.org>


In order to make the dbms generate the same sort of histograms would I replace the line to be as:
method_opt =3D> 'FOR TABLE FOR ALL INDEXES FOR ALL INDEXED COLUMNS SIZE 254'

Is that the correct syntax?
Thanks

--
..
David


>> Not that it directly answers your question, but I see that the method
>> differs: you have ANALYZE collecting histograms with 254 buckets on
>> indexed columns (and I believe implicitly on every other column with 1
>> bucket), while DBMS_STATS is generating 254-bucket histos on all
>> columns.
---------------------------------------------------------------- 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 - 12:04:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US