Re: slow Subquery
This might be better, the subquery will become independent of the main query and only need to be done once instead of for every row of the LARGE table.
SELECT *
FROM LARGE
WHERE L IN (SELECT S
FROM SMALL);
Try and see what does EXPLAIN gives you.
Subject
Views
Written By
Posted
3737
November 12, 2004 12:32AM
2344
November 12, 2004 12:55AM
Re: slow Subquery
2510
November 12, 2004 01:19AM
2598
November 13, 2004 12:00AM
2878
November 14, 2004 01:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.