Oracle 9i Optimiztion methond question

I recently came accross a reference that when installing theEnterpriseOne server with Oracle it changes the optimization to rule base optimization.

However our Oracle instance currently has an optimization method set to "choose". We recently replaced our database server and I am wondering if this could have possibly been changed.

Can anyone with Oracle9i installation share what optimization they are using.

I doubt that a JDE install changes the dbms optimization parameter.
Ours is set to the default value also, which is CHOOSE.

here is a good description of the different choices for this parameter: Oracle SQL Optimizer Rules

Changing to rule based optimization isn't something I would recommend unless you have a reason to do so. This was left in for backwards compatibility in 9i.

Also don't use analyze instead use the DBMS_STATS to generate data stats.

If you want to see the affect of a query with the rule optmizer you can always run it with /*RULE/* hint.