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: Improve query performance

Re: Improve query performance

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Tue, 09 Dec 2003 21:47:22 +0100
Message-ID: <k5dctv8ta55j1gria6s2900rgut1dsn5tu@4ax.com> 





On 9 Dec 2003 07:49:34 -0800, danielroy10junk_at_hotmail.com (Daniel Roy)
wrote:



>What I've seen so far is that NOT EXISTS performs much

>better than NOT IN, but that depends on the volumes of data, of

>course.




According to Thomas Kyte in his latest book this is a myth.



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Dec 09 2003 - 14:47:22 CST












Original text of this message













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