Re: SQL code tuning

"Stefan Olausson" <qhsstol_at_hotmail.com> wrote in message news:fda9c411.0111010841.7f649a40_at_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,

Sorry to have to contradict you on this, but development on RBO stopped with 7.1. You can easily track that down in similar articles in Metalink.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address