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.

Answer the question

50 XP

Possible Answers

The written order of joins in a CTEs matches the order of execution seen in the query planner.
press1
CTEs are only executed once per query, even if they are referenced more than one time in the parent query.
press2
CTEs create a temporary table.
press3
If a column with an index is referenced in a CTE, the index is also available outside of that CTE.
press4