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 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?