Re: Fed Up with being a DBA

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)