Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> When does performance worsen when going from RULE to COST

When does performance worsen when going from RULE to COST

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Sat, 5 Feb 2000 13:42:01 +0100
Message-ID: <uJIkTZ9b$GA.275@net025s>


Hi g's,

When you want to change a database from rule based to cost based you're naturally are going to be worried somewhat about the general and query specific effects

My question: Are there general causes for degradation people stumble upon when doing this change? This of course under the assumption that every table has been analyzed (ANALYZE TABLE <name> COMPUTE STATISTICS).

For example (one I've seen often): the rule based optimizer uses an index, and the cost based doesn't under the false assumption that a literal in the WHERE clause is one of the evenly distributed values of a column, where in fact it is a very rare value (e.g. the literal 'F' for the column GENDER for a personnel table in a database used by the army). Of course this can be gotten rid of by gathering histogram statistics for this column, but solving this particular example is not the issue here.

Jaap. Received on Sat Feb 05 2000 - 06:42:01 CST

Original text of this message

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