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

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie sql question...

Re: newbie sql question...

From: daniel <test_at_test.com>
Date: Thu, 21 Mar 2002 20:19:02 -0000
Message-ID: <a7df5g$u09$1@newsg1.svr.pol.co.uk>


suck it and see, try an explain plan

daniel...

"paul" <pquigley_at_whpi.com> wrote in message news:98da33ef.0203211214.754130cf_at_posting.google.com...
> if i use the <> operator in a query, e.g.
>
> T1.PRIV_FLG != :4 AND T1.X_STATUS != :4
>
> will the index on these columns be ignored ??
>
>
>
> thanks in advance...
Received on Thu Mar 21 2002 - 14:19:02 CST

Original text of this message

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