Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> parallel and append hint in insert statement
I have a statement as below:
INSERT /*+ APPEND */ INTO emp
SELECT /*+ PARALLEL (temp_emp, 4) */ FROM temp_emp
As you can see, SELECT is set to perform in 4 processes. Will the insert also be executed by 4 parallel processes without the explicit PARALLEL hint in the insert clause, since the select is done in parallel? Or do I have to add the parallel hint in the insert clause also as below?
INSERT /*+ APPEND PARALLEL(emp, 4) */ INTO emp SELECT /*+ PARALLEL (temp_emp, 4) */ FROM temp_emp
Thanks in advance. Received on Thu Apr 21 2005 - 23:33:36 CDT