Hi,
In my SQL there are 2 WITH clauses which are independent to each other but at the end i am doing UNION ALL to combine both the result sets. As 2 with clauses are taking lot of time to execute before combining them.
If oracle can execute both the with clauses simultaneously i can save lot of execution time.
Here is the sample SQL.
with temp1 as
(
select
...............
......................
table1,table2
..
) ,
temp2 as
(
select
...............
......................
table3,table4
..
)
select * from temp1
union all
select * from temp2;
I want temp1 and temp2 tables need to executed simultaneously as they both are independent to each other.
If any can help me with the process to execute both WITH clauses @ same time it would be highly appreciated.
Regards,
Srinath