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

Wolfgang,

        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
>=20

--=20
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: