RE: Simple SQL Query
- From: "Blanchard, William" <wblanchard@xxxxxxxxxxxxxxxxxxxx>
- To: <panibabu.mail@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Jan 2010 11:28:13 -0600
Two suggestions, indexes and minus.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Pani Babu
Sent: Thursday, January 07, 2010 11:04 AM
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?
Other related posts: