Re: doubt in sql

From: Svend Jensen <svend.SPAMKILLjensen_at_secret.dk>
Date: Thu, 31 Mar 2005 09:10:44 +0200
Message-ID: <424ba2e5$0$156$edfadb0f@dread11.news.tele.dk>

rasukutty wrote:
> 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?
>

You doen't.
Where's the difference between full scan and full scan? You tell me, and I explain the performance difference. If full scan is a problem, fix it.
/Svend Received on Thu Mar 31 2005 - 01:10:44 CST