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: IN vs NOT IN

Re: IN vs NOT IN

From: Steven Findlay <findlays_at_unbc.ca>
Date: Thu, 07 Dec 2000 10:29:12 -0800
Message-ID: <3A2FD6F8.5060801@unbc.ca> 






The NOT In requires a full table scan well the IN clause can use the 
index that is associated with the column you are processing against...
Received on Thu Dec 07 2000 - 12:29:12 CST












Original text of this message













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