Re: SQL code tuning

From: Stefan Olausson <qhsstol_at_hotmail.com>
Date: 1 Nov 2001 08:41:09 -0800
Message-ID: <fda9c411.0111010841.7f649a40@posting.google.com>

> So when all things are equal the *rule based optimizer*, which
> is obsolete since 1994...

I personally havent worked with CBO in
Oracle 7, but judging from this document:

"The Search For Intelligent Life In The Cost-based Optimizer" http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2=abs133 (free registration required to download the full doc)

it really wasnt until Oracle8.0 (or maybe 8i) that the RBO became "obsolete".

Very worthwhile article, anyway.

Best Regards, Received on Thu Nov 01 2001 - 10:41:09 CST