Re: SURVEY RBO VS CBO

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 26 Oct 2001 11:16:25 +0200
Message-ID: <ttialrfrg2hh86@corp.supernews.com>

"FrantzG" <fguionne_at_hotmail.com> wrote in message news:9rb93q$dm5$1_at_news.businessobjects.com...
> Hi All,
>
> A lot has been said about Ruled Based Optimizer VS Cost Based Optimizer
but
> I would like to launch this quick survey :
> Which one are you currently using in Production ? and what version of
Oracle
> are you currently on ?
>
> Thank You
> Frantz Guionnet
>
>

No need for such a survey
The RBO didn't change since 1994, is obsolete and shouldn't be used anymore. Anyone using parallel query, partitioning, function based indexes etc etc etc etc
simply has to use CBO.
RBO is just like DOS : a dead horse.

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 26 2001 - 04:16:25 CDT