Re: SURVEY RBO VS CBO

From: FrantzG <fguionne_at_hotmail.com>
Date: Wed, 31 Oct 2001 09:13:31 +0100
Message-ID: <9roeff$5qf$1@news.businessobjects.com>

Thany you all !

Frantz Guionnet

"Fuzzy" <freewarez42_at_yahoo.com> wrote in message news:79824c2.0110291507.290888a8_at_posting.google.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
>
> This should satisfy you that RBO is dead.
>
> Our app is deployed on approx 200 instances at 150+ sites around the
> world, versions 7.3.4 - 8.1.7
>
> ~50% solaris
> ~25% hp-ux
> ~20% nt/2k
> the rest aix, tru64 etc.
>
> and they are all running CBO.
>
> RIP RBO
>
> Ciao
> Fuzzy
> :-)
Received on Wed Oct 31 2001 - 02:13:31 CST