Simple SQL Query

From: Pani Babu <panibabu.mail@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 7 Jan 2010 12:03:32 -0500

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?

Follow-Ups:
- RE: Simple SQL Query
  - From: Joel Slowik
- Re: Simple SQL Query
  - From: Stephane Faroult
- RE: Simple SQL Query
  - From: Goulet, Richard
- RE: Simple SQL Query
  - From: Blanchard, William
- RE: Simple SQL Query
  - From: Michael McMullen
- Re: Simple SQL Query
  - From: Adam Musch

Other related posts:

» Simple SQL Query - Pani Babu
» RE: Simple SQL Query- Joel Slowik
» Re: Simple SQL Query- Stephane Faroult
» Re: Simple SQL Query- Don Seiler
» RE: Simple SQL Query- Goulet, Richard
» RE: Simple SQL Query- Blanchard, William
» RE: Simple SQL Query- Michael McMullen
» Re: Simple SQL Query- Adam Musch