RE: Optimizer change from 8i-9i

>>1. For SQLs using RBO, the plan for the existing SQL won''t change,
>>right? As oracle says no change for RBO since oracle 7.3.
>
>Wrong. You could see some differences.

Let me precise this point...=20

There are two reasons that lead to different execution plans with the = RBO:
1) Differences in the optimizer itself.
2) The indexes of the new database are not created in the same order as = the indexes of the old one.

--
http://www.freelists.org/webpage/oracle-l