Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tim Gorman's "...Cost-Based Optimizer.doc"

Re: Tim Gorman's "...Cost-Based Optimizer.doc"

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 16 Jun 2005 11:58:39 -0600
Message-ID: <42B1BDCF.8050804@centrexcc.com>


Could that be that many systems, especially in COTS, were designed and written at a time when the RBO "ruled" and therefore the design and the sql are tuned around the RBO?

Goulet, Dick wrote:

> What really gets to me with the CBO is that often a simple /*+ RULE */
> does the trick=20
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 16 2005 - 14:03:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US