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...