Correlated Subqueries

Correlated subqueries are subqueries that reference the outer query and runs once per row instead of once total. This chapter goes deep into how correlated subqueries actually execute, the patterns they unlock, and when to replace them with something faster.