#11 - Unnesting Queries (CMU Optimize!)
CMU Database Group · 74:15
This CMU advanced-database lecture explains why correlated SQL subqueries are hard to optimize and how to unnest them safely: treat a nested query as a function of the outer query, rewrite it into joins the optimizer...