RE: Simple SQL Query
Date: Thu, 7 Jan 2010 12:21:23 -0500
What database version???
Senior Oracle DBA/NA Team Lead
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Pani Babu Sent: Thursday, January 07, 2010 12:04 PM To: oracle-l_at_freelists.org
Subject: Simple SQL Query
I have a simple SQL query which lists all the records that are not in a second table.
select first.id from first
where first.id 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?