Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Optimizer Question
I'm using a Oracle 8.0.4. Database on a Unix system and using the Cost Based
Optimizer. When I submit a select statement does Oracle use only the Cost
Based Optimizer OR does it use a combination of the Cost Based and Rule Bases
Optimizers without any hints?
I was told that Oracle uses both Cost Based and Rule Based Optimizers on the select statement at the same time with the database running in Cost Based mode.
I'm trying to confirm if the above statement is true or just B.S.
Thanks
Russ
imrad_at_icubed.com
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 16 1998 - 11:54:50 CST