RE: rm RULE based optimizer != GOOD IDEA

  • From: "Post, Ethan" <Ethan.Post@xxxxxx>
  • To: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • Date: Fri, 22 Apr 2005 07:56:45 -0500

I guess my question would be why?  Is the engine going to be faster
because they have removed this bit of code?  Maybe you stop supporting
it but why make it impossible to use as a tool in the future?=20

-----Original Message-----
From: Christian Antognini [mailto:Christian.Antognini@xxxxxxxxxxxx]=20
Sent: Friday, April 22, 2005 4:22 AM
To: Post, Ethan
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: rm RULE based optimizer !=3D GOOD IDEA

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

--
//www.freelists.org/webpage/oracle-l

Other related posts: