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.
Changing over to CBO could cause problems if you dont have direct access to
the queries. This is fairly common with low cost 3rd party applications.
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1074183767.537988_at_yasure...
> James A. Williams wrote:
>
> > Running on a 9.2.0.4 database. Its a vendor app that can't support CBO
> > yet!
> >
>
> Your assumption that you are RBO because of the vendor is not valid.
> Oracle can still use CBO and may well be doing just that.
>
> Tom Kyte - "Effective Oracle by Design" - See the note at the top of
> page 340.
>
> --
> 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 Thu Jan 15 2004 - 12:11:16 CST
