RE: hinting and the rule based optimizer

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 1 Apr 2004 14:10:19 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00335@EXCHMN3>

Ryan

   Use the RULE hint.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan.gaffuri_at_cox.net Sent: Thursday, April 01, 2004 2:04 PM
To: oracle-l_at_freelists.org
Subject: hinting and the rule based optimizer

We have a legacy 8.1.7.3 instance that is in RBO mode. My group does not own it, so we cannot change it to CBO.

When I hint anything from an index to ordered, etc... it switches to the CBO and since nothing is analyzed, it's an even worse plan... Not allowed to analyze the tables either because it's not our property.

Any rules around hinting the RBO in 8.1.7.3? Why would it switch to the CBO from a simple hint? I never use the RBO so please bare with me.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Apr 01 2004 - 14:19:45 CST