Dear Experts,
I have two huge table almost 300 GB each.
create table as
select * from table t1 ,t2
where t1.row_id=t2.row_id
How to execute this query in parllelism. Withou Parlell it is taking too much time.
like is it should be
create table parallel 15 as
select * from t1,t2;
or some other way
and what if it there is 3 table to take join from