Currently I am running the following (simplified) query:
INSERT /*+ APPEND */ INTO NEW_TAB (ID)
SELECT DISTINCT T1.BIG_ID
FROM BIG_TAB1 T1, BIG_TAB2 T2
WHERE T1.BIG_ID = T2.ID2
AND T2.METHOD = 1
AND T1.CODE IN ( /*16 codes here*/ );
When this migrates to the production platform the DBAs have asked me to code it for parallel processing.
We implement 4 processors for parallel processing and so usually I would do the following hint between INSERT and INTO;
/*+ PARALLEL (BIG_TAB1, 4) */
As my query here accesses two tables how would I modify this statement to make it run in parallel? Would it be;
INSERT /*+ PARALLEL (BIG_TAB1, 4) */ /*+ PARALLEL (BIG_TAB2, 4) */ INTO NEW_TAB (ID)
SELECT DISTINCT T1.BIG_ID
?
Thanks for any help!
fakelvis