Re: Query improvement on 9.2.0.4

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 15 Jan 2004 22:27:45 -0800
Message-ID: <1074234390.959275@yasure>

James Williams wrote:

> On Thu, 15 Jan 2004 13:11:16 -0500, "Ryan" <rgaffuri_at_cox.net> wrote:
>
>

>>many 3rd party applications write code specifically for the RBO. They wrote
>>these applications several years ago and did not spend the money to test
>>them in the CBO. You might also invalidate your support contract with the
>>3rd party vendor.
>>

>
> I have tried to convert this instance to CBO three times and each time
> I had to back off because of the code.
>
> The above query is a user created query a user is working on under the
> RBO.
>
> No statistics exist in this database.

If it is a user written query there is no excuse for it. There is no reason not to use the CBO.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Jan 16 2004 - 00:27:45 CST