Oracle hint: MATERIALIZE

/*+ materialize */ is an undocumented hint.

The hint causes the result of a query in a with clause to be stored in a global temporary table.

Thus, the hint is useful if this result is referred to multiple times in the query. Compare with cache and inline. Apparently, an inline view is materialized when it uses rownum.