Is there anyway to enable parallel execution at the statment level when more than one table is involved in the query (ie. join)? I
don't want to set the parallelism at the table level.
Typically, a hint can be included to enable parallelism at the statement level (ie. SELECT /*+ PARALLEL (table1, 4) */ ), but how can this be enabled for EACH table in the FROM clause?
when one table is parallelized then all involved tables are as well
bse, you can /*+ PARALLEL(table1,4) PARALLEL(table2,2) etc */
pando, I don't think that can be right. If it was you wouldn't see PARALLEL_FROM_SERIAL in an explain plan.