3 ms·
You might want to test using the first query as a sub-query or cte in the second one. That would likely give you the same / better perf. It would avoid the joi
by anshul 4y ago
You might want to test using the first query as a sub-query or cte in the second one. That would likely give you the same / better perf. It would avoid the join and save a round trip.
- hobs 4y agoIf 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