Re: SQL code tuning

On Thu, 1 Nov 2001, postbus_at_sybrandb.demon.nl wrote:

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

[...]

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

The article says that the RBO was finally made obsolete in 8 to 8i. and this seems to be what Stefan was saying. Not that development on it persisted into 8.0.

,----[ FROM THE ARTICLE ]
| The only thing that the CBO seemed to have going for it was that
| it supported all of the nifty new features introduced by Oracle
| from version 7.1 onwards. It seemed that risking the use of the
| CBO was the price one paid in order to use new features. Other
| than that, conventional wisdom holds that you stick with the RBO
| unless you thrive on stress and regret.
|
| Although the situation with the CBO quietly became drastically
| better in Oracle8 v8.0 and has become orders of magnitude better
| in Oracle8i, this widely held perception persists.
`----

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.