Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise