RE: Optimizer change from 8i-9i

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <zhuchao@xxxxxxxxx>
  • Date: Mon, 9 May 2005 18:30:15 +0200

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

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

Other related posts: