Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rm RULE based optimizer != GOOD IDEA

RE: rm RULE based optimizer != GOOD IDEA

From: Post, Ethan <>
Date: Fri, 22 Apr 2005 12:24:44 -0500
Message-ID: <>

The "our developers are lazy" argument is not a good reason to get rid of something. The only valid reason I see so far is that Oracle has a significant amount of work to do to maintain the RULE engine. I have never seen the code for this so I would not know but will take it for granted that this is true (must be more than 20 simple rules).

Not sure what you mean by "there is no baseline to tune it from?". Would you have a baseline if they added a INDEX hint? You could remove the INDEX hint also. You could update the stats on a table and have all sorts of changes to queries, some fast some slower, what is your baseline there?

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

From: Robyn []=20 Sent: Friday, April 22, 2005 12:12 PM
Cc: Post, Ethan; Christian Antognini; Peter Ross Sharman Subject: Re: rm RULE based optimizer !=3D GOOD IDEA

I for one will be happy to see the rule based optimizer go. Most of our developers and dbas add rule hints as a quick fix without taking the time to actually figure out the problem. Then, they announce that the query completed 'really fast' in dev and move it to production, where it may or may not run 'really fast'. Either way, there is no baseline to work from if we need to continue to tune it. Plus, the rule hint is likely to exist through the next 3 upgrades, and no one remembers that it exists, much less knows if it's still making things 'really fast'.

As a result, we have lots of legacy queries that need to be reevaluated and there have been many times when REMOVING the rule hint in an old query sped things up considerably.

As for the oic and oica, implementing system statistics seemed to negate the effect.

-- Received on Fri Apr 22 2005 - 13:29:38 CDT

Original text of this message