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: WHERE NOT ...

Re: WHERE NOT ...

From: Vjoshi2 <vjoshi2_at_aol.com>
Date: 4 Jul 1998 09:49:01 GMT
Message-ID: <1998070409490100.FAA22613@ladder01.news.aol.com> 





HI,


When the optimzer sees the NOT <> clauses it does not use indexes.
In oracle even if you include a IS NULL that would result in doing a full table
scan.


The only way around this, make sure your field(s) have initial values.
Ie every single row will have value(s) in them.
Received on Sat Jul 04 1998 - 04:49:01 CDT












Original text of this message













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