Re: slow Subquery

[Dominique Duay]

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);