Simple SQL Query

From: Pani Babu <panibabu.mail_at_gmail.com>
Date: Thu, 7 Jan 2010 12:03:32 -0500
Message-ID: <6abafc981001070903p336d01e5i416d04d8d0ded185_at_mail.gmail.com>

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 query. Is there a way to rewrite the query to run it quicker?

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 07 2010 - 11:03:32 CST