Re: Simple SQL Query

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Thu, 07 Jan 2010 18:10:38 +0100
Message-ID: <4B46158E.9030002_at_roughsea.com>

A left outer join should do the trick reasonably well.

HTH SF

Pani Babu wrote:
> I have a simple SQL query which lists all the records that are not in
> a second table.
>
> select first.id <http://first.id> from first
> where first.id <http://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:10:38 CST