Materialized CTE

What Does It Mean for a CTE to be Materialized?

A materialized CTE is one the database engine fully computes and holds in a temporary work area exactly once, before the outer query runs against it, as oppose…