Flashcard
CTE Materialization vs Inlining
Understanding when CTEs act as optimization fences versus inlined subqueries determines join performance.
Question
Why can a CTE hurt performance versus an equivalent subquery or derived table?
Click to reveal answer