When you use the NOT clause Oracle can't indexes on the associate(s)
column(s)
"Brian Z" <bzamborski_at_uss.com> a écrit dans le message de news:
77fd0218.0109180259.5b8826f2_at_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 - 06:14:16 CDT
