Subqueries & CTEs

JOIN Optimization

Window Functions

Rewrite subqueries as JOINs

Use EXISTS

Optimize correlated

Subquery vs JOIN?

Correlated performance?

EXISTS vs IN?

Subquery Optimization

Query Rewriting