Re: Improve query performance

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 09 Dec 2003 13:55:36 -0800
Message-ID: <1071006972.76046@yasure>

Sybrand Bakker wrote:

> 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

I've repeatedly proven it is a myth. And even when it wasn't ... the result was entirely dependent upon on the arrangement of the larger and smaller tables.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Dec 09 2003 - 15:55:36 CST