ENABLE_WITH_CLAUSE_MATERIALIZATION

Enables and disables WITH clause materialization for a specific query. Materialization is automatically cleared when the query returns. For more information, see Materialization of WITH Clause in Analyzing Data.

Syntax

WITH /*+ENABLE_WITH_CLAUSE_MATERIALIZATION*/ with-query...