RE: Optimizer change from 8i-9i

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Wed, 11 May 2005 15:48:26 +0200
Message-Id: <20050511134823.105508011141@smtp-out1.tiscali.nl>

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.  

---

Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html

---

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