MySQL Forums
Forum List  »  Performance

Re: slow Subquery
Posted by: Dominique Duay
Date: November 13, 2004 12:00AM

Thanks, but it doesn't help.

The only way I found to make it quicker is to write it as follows, but can't we optimize the firs solution with thinks like straight_join (for subqueries).

SELECT *
FROM SMALL
WHERE S IN (SELECT L
FROM LARGE);

SELECT *
FROM SMALL
WHERE EXISTS (SELECT *
FROM LARGE
WHERE L = S);

Options: ReplyQuote


Subject
Views
Written By
Posted
3488
November 12, 2004 12:32AM
2222
November 12, 2004 12:55AM
2384
November 12, 2004 01:19AM
Re: slow Subquery
2485
November 13, 2004 12:00AM
2759
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.