Re: optimal sql

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 11 Dec 2002 08:49:22 +0100
Message-ID: <3DF6EE02.3090101@science-computing.de>

Have a look at http://asktom.oracle.com and search for 'not exists'. There are a couple of threads on the topic which might help you to decide when 'not in ' or 'not exist' is appropriate. You probably already have learned from the previous posts, that there is never an absolute answer - it depends completely on the data you are querying. (Although some of the posters seemed to be ignorant of the fundamental differences between 'not in' and 'not exists' - I was among them too a couple of weeks ago ;-)

Regards,

Holger Received on Wed Dec 11 2002 - 01:49:22 CST