4 ms·
If you dont need the output of the first query you'll almost always have the best performance in sql using exists syntax eg select * from query1 as q where ex
by hobs 4y ago
If you dont need the output of the first query you'll almost always have the best performance in sql using exists syntax eg
select *
from query1 as q
where exists
(
select *
from query2 as q2
where q.col = q2.col
)
- nfcampos 4y agoYes although in this specific case you’d lose the order of the results with exists