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
3959
November 12, 2004 12:32AM
2485
November 12, 2004 12:55AM
Re: slow Subquery
2620
November 12, 2004 01:19AM
2711
November 13, 2004 12:00AM
2967
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.