Materialize a Subquery without using "with" clause
653212Sep 21 2010 — edited Oct 4 2010Hi experts,
We know that we can materialize a subquery as below :
with sub_q as
( select /*+ materialize */ a,b,c from table_name )
select * from sub_q;
My question is, is there any other way to force a subquery be materialized by writing straight as below ?:
select * from
( select a,b,c from table_name );
Thanks in advance.