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: Index is not getting in use if I add one more condition

Re: Index is not getting in use if I add one more condition

From: <sybrandb_at_gmail.com>
Date: Wed, 21 Mar 2007 22:57:48 +0100
Message-ID: <jga303tlil09gfo6savfip0ajn9ever0l3@4ax.com> 





On 20 Mar 2007 19:00:37 -0700, "Steve Robin" <ocmaman_at_gmail.com>
wrote:



>I apologies, but I don't remember any condition like this(IsDel).




How about this


> > SQL> EXPLAIN PLAN FOR


> >   2  SELECT COUNT(1) FROM SC_ORG WHERE SC_ORG.ORG_TYPE =2 AND


> > (SC_ORG.IsDel = :1)

>




Also note in both statements different implicit conversions!!!



-- 
Sybrand Bakker
Senior Oracle DBA


Received on Wed Mar 21 2007 - 16:57:48 CDT












Original text of this message













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