Re: SURVEY RBO VS CBO

From: Fuzzy <freewarez42_at_yahoo.com>
Date: 29 Oct 2001 15:07:02 -0800
Message-ID: <79824c2.0110291507.290888a8@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 Mon Oct 29 2001 - 17:07:02 CST