Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Optimizer change from 8i-9i
just to confirm, the PS of Christian is *very* true;
during parsing, statement transformation takes place *before* the optimizer (RBO
or CBO) is invoked...
kind regards,
Lex.
-----Original Message-----
PS: My guess is that the core of the RBO itself has not changed (except, =
perhaps, to fix bugs). But, before a statement is send to it, some =
transformation can be applied (like complex view merging). Therefore = another
execution plan is generated because the RBO works on a different = statement and
not because the RBO itself has changed.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 11 2005 - 09:52:59 CDT
![]() |
![]() |