RE: Simple SQL Query

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <panibabu.mail@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 7 Jan 2010 12:21:23 -0500

What database version???

Dick Goulet 
Senior Oracle DBA/NA Team Lead 
PAREXEL International 



From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Pani Babu
Sent: Thursday, January 07, 2010 12:04 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Simple SQL Query

I have a simple SQL query which lists all the records that are not in a
second table.

select from first
where not in (select id from second);

As the second table is very huge, it takes a very long to process the
Is there a way to rewrite the query to run it quicker?

Other related posts: