Re: Fed Up with being a DBA

As soon as Oracle starts using CBO, after that I will give it a second change.
Oracle Application 11i uses stil that old RBO !

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1063413461.186554_at_yasure...
> Alan wrote:
>
> >I haven't run any tests to prove this, but I was told by Someone Who
Should
> >Know (a certfied Oracle Instructor) that CBO can't optimize a query any
> >better than a _properly_ optimized RBO query.
> >
> ><snipped>
> >
> >
> I am amazed you believed what you were told as the statement is patently
> false on its face.
>
> The RBO is worthless for any feature that is new to 8i or 9i.
>
> How does RBO handle a partitioned table?
> How does RBO handle an IOT?
> How does RBO handle a nested table?
> How does RBO handle .... and on and on and on.
>
> So unless you plan on writing version 7 code for the rest of your life
> ... how can you possibly use the RBO?
>
> --
> 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 Mon Sep 15 2003 - 02:50:56 CDT