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 -> Indexable Predicates in ORACLE -- Help!

Indexable Predicates in ORACLE -- Help!

From: Brian Z <bzamborski_at_uss.com>
Date: 18 Sep 2001 03:59:27 -0700
Message-ID: <77fd0218.0109180259.5b8826f2@posting.google.com> 





I have some experience with DB2, but minimal knowledge of Oracle. Is
there a listing of what predicates are indexable in Oracle?? I.E. If I
have a 'Where acol not in ('a','b') --- is this indexable? Is anything
indexable when a 'NOT' is used? In DB2, this negates the use of an
index...I wanted to know if this is the same in Oracle. Thanks in
advance!
Received on Tue Sep 18 2001 - 05:59:27 CDT












Original text of this message













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