Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> parallel and append hint in insert statement

parallel and append hint in insert statement

From: Steve Howard <august4me_at_yahoo.com>
Date: 21 Apr 2005 21:33:36 -0700
Message-ID: <41f4cf3c.0504212033.323d8f@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US