Re: Simple SQL Query

From: Stephane Faroult <>
Date: Thu, 07 Jan 2010 18:10:38 +0100
Message-ID: <>

A left outer join should do the trick reasonably well.


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

Received on Thu Jan 07 2010 - 11:10:38 CST

Original text of this message