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 -> doubt in sql

doubt in sql

From: rasukutty <rajendranr_at_systechusa.com>
Date: Fri, 25 Mar 2005 05:28:08 -0500
Message-ID: <a9d2733e771133016fd1190a74c138d1@localhost.talkaboutdatabases.com> 





I want to know the difference between IN and NOT IN with regard to
performance.If Both are going to do full scan on the table then how is one
going to perform over the other?
Received on Fri Mar 25 2005 - 04:28:08 CST












Original text of this message













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