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

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx>
  • Date: Thu, 16 Jun 2005 14:05:20 -0400


        That's probably an absolute truth.  But I can guarantee you that
it rules when working with the data dictionary.=20

-----Original Message-----
From: Wolfgang Breitling [mailto:breitliw@xxxxxxxxxxxxx]=20
Sent: Thursday, June 16, 2005 1:59 PM
To: Goulet, Dick
Cc: somckit.khemmanivanh@xxxxxxxxxxxxxxxx; cmarquez@xxxxxxxxxxxxxxxx;
mgogala@xxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Tim Gorman's "...Cost-Based Optimizer.doc"

Could that be that many systems, especially in COTS, were designed and=20
written at a time when the RBO "ruled" and therefore the design and the=20
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=3D20


Wolfgang Breitling
Centrex Consulting Corporation

Other related posts: