Why the difference?
The execution plan differs when using a subquery versus a common table expression (CTE) structure.
The following statements describe execution rules that are only true for CTEs. Choose the statement that does NOT describe a difference in the execution between a subquery and CTE.
This exercise is part of the course
Improving Query Performance in PostgreSQL
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
