Re: Simple SQL Query
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: panibabu.mail@xxxxxxxxx
- Date: Thu, 07 Jan 2010 18:10:38 +0100
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
