Y
Hacker News
new
|
ask
|
show
|
jobs
by
hobs
1403 days 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 )
1 comments
nfcampos
1402 days ago
Yes although in this specific case you’d lose the order of the results with exists
link