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