SQL Performance using JOIN instead of IN CLAUSE

Viewed 9306

I see a lot of places suggesting using INNER JOIN's instead of writing IN CLAUSES because of performance reasons. None of them explain why, though. Can someone provide a detailed explanation why that is?

0 Answers
Related