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 -> Re: Why does optimizer determine wrong cardinality when using MOD function? test included

Re: Why does optimizer determine wrong cardinality when using MOD function? test included

From: peter <p_msantos_at_yahoo.com>
Date: 17 Nov 2005 08:44:40 -0800
Message-ID: <1132245880.808349.95040@g47g2000cwa.googlegroups.com> 





Thanks for the explanation Amit.


Unfortunately, our customers don't always use mod(id_column,2) = 0 ,
sometimes they use different values and so a specific function based
index would probably not work.



thanks


-peter
Received on Thu Nov 17 2005 - 10:44:40 CST












Original text of this message













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