In 9.2 the default for OPTIMIZER_MODE was CHOOSE. CHOOSE meant use the rule-based optimizer if none of the tables in the query have statistics. In Oracle 10.1 the Rule-based optimizer is officially "desupported" (see metalink note notice 189702.1). So CHOOSE is no longer a valid option. Therefore the default has been changed. Why is the default ALL_ROWS instead of FIRST_ROWS_1, for example? That I don't know. -----Original Message----- jaysingh1@xxxxxxxxxxxxx Does anybody have an idea why oracle made default optimizer_mode=ALL_ROWS in 10g windows. I didn't check other platforms. ---------------------------------------------------------------- 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 -----------------------------------------------------------------