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@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 -----------------------------------------------------------------