Re: RBO to CBO

From: Jack <none_at_mail.com>
Date: Thu, 30 Dec 2004 14:13:42 GMT
Message-ID: <q2UAd.483$XJ6.37@read3.inet.fi>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:41d37c6f$0$11881$afc38c87_at_news.optusnet.com.au...
> Oradba Linux wrote:
>> Any major/minor issues to watch out for during the conversion especially
>> with regards to sql written specifically to RBO
>
>
> Yup, a fairly major point: code written specifically for the RBO usually
> ends up performing abysmally under the CBO. Unless you're planning to
> effectively start from scratch, and gather execution plans for every SQL
> statement, you can expect trouble.
>

Well, one possibility is to stay in RBO, at least for a while. It still works quite well in 9iR2, and without extra work. Received on Thu Dec 30 2004 - 08:13:42 CST