Hi
And also the hint should be something like where N is number of CPU's on the
box into 2
INSERT INTO TT_TBL (...)
SELECT /*+ PARALLEL(TT N) */
TT.*
FROM ANOTHER_TEMP_TBL TT
LEFT JOIN T1 ON TT.FK = T1.PK
LEFT JOIN T2 ON T1.FK = T2.PK
WHERE ...
--
//www.freelists.org/webpage/oracle-l
