Jack wrote:
> "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.
Provided you only use table and index types that existed in Oracle 6.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Dec 30 2004 - 12:04:44 CST
