i have an insert statement i am running in parallel using a parallel hint, i would like to also parallel the select however it uses 2 tables, which table should I use the parallel hint in the select.
insert /*+PARRALLEL(A,4)*/ into A
select b.num,c.num,c.value,c.name,b.name
from b,c
where b.key=c.key
insert /*+PARRALLEL(A,4)*/ into A
select b.num,c.num,c.value,c.name,b.name
from b,c
where b.key=c.key
