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: rm RULE based optimizer != GOOD IDEA

RE: rm RULE based optimizer != GOOD IDEA

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 22 Apr 2005 11:21:53 +0200
Message-ID: <7F0C000A3ABA6241A10C9ABF37EEB46D0406BD@MSXVS01.trivadis.com>


Hi

>And again,
>the argument is why spend time trying to figure this out, no matter how
>wonderful the CBO becomes, it will occasionally screw up, and if all I
>need to do is add +RULE and walla! then I think that feature better =
stay
>(at the statement level for the very least). Just an argument to keep
>RULE around, I can't recall what Oracle says the status of this is.

The feature is already gone. In "Oracle Database Performance Tuning = Guide 10g Release 1" you can read:
"The CHOOSE and RULE optimizer hints are no longer supported. The = functionalities of those hints still exist but will be removed in a = future release."

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 22 2005 - 05:26:06 CDT

Original text of this message

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