Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!feeder1-2.proxad.net!64.233.178.134.MISMATCH!postnews.google.com!i13g2000prf.googlegroups.com!not-for-mail
From:  ACMIC <AACARMICHAEL@THEBLUEZONE.NET>
Newsgroups: comp.databases.oracle.misc
Subject: Re: "Not in" subquery
Date: Wed, 06 Jun 2007 15:07:05 -0700
Organization: http://groups.google.com
Lines: 10
Message-ID: <1181167625.534838.18280@i13g2000prf.googlegroups.com>
References: <1181161299.089723.172190@g37g2000prf.googlegroups.com>
NNTP-Posting-Host: 65.90.138.183
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1181167626 13133 127.0.0.1 (6 Jun 2007 22:07:06 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 6 Jun 2007 22:07:06 +0000 (UTC)
In-Reply-To: <1181161299.089723.172190@g37g2000prf.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: i13g2000prf.googlegroups.com; posting-host=65.90.138.183;
   posting-account=JEFC-A0AAACSvx_59oH7Mtqc120WDvmM
Xref: news.f.de.plusline.net comp.databases.oracle.misc:79875

insead of using not in use not exists.... this is alot faster....


SELECT . . .
FROM   emp E
WHERE  NOT EXISTS ( SELECT  X'
                       FROM   dept
                       WHERE  dept_no  = E.dept_no
                       AND    dept_cat = 'A'   );