Core concept

Complex correlated subqueries may not translate well.

Advertisement

How it works

Test complex CTEs. Rewrite if plan bad.

Advertisement

Trade-offs + gotchas

Reusing intermediate results. Complex analytics.