RE: Simple SQL Query

From: Goulet, Richard <>
Date: Thu, 7 Jan 2010 12:21:23 -0500
Message-ID: <>

What database version???  

Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International  

[] On Behalf Of Pani Babu Sent: Thursday, January 07, 2010 12:04 PM To:
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 query.
Is there a way to rewrite the query to run it quicker?

Received on Thu Jan 07 2010 - 11:21:23 CST

Original text of this message