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

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_at_centrexcc.com]=20 Sent: Thursday, June 16, 2005 1:59 PM
To: Goulet, Dick
Cc: somckit.khemmanivanh_at_weyerhaeuser.com; cmarquez_at_collegeboard.org; mgogala_at_allegientsystems.com; oracle-l_at_freelists.org 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