Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

two parallel hints in a merge statement

sathya_mounikaOct 1 2013 — edited Oct 2 2013

I am not sure if using the parallel hint in such a way as below would be helpful in parallelizing the query run. Can a parallel hint be used for two different tables in a merge statement like mentioned below?

MERGE INTO /*+ parallel (TABLE_A,8) */ TABLE_A  A

USING( SELECT /*+ parallel (TABLE_B,8) */

                        col1,

                        col2

              FROM TABLE_B

         )  B

ON A.col1 = B.col1

WHEN MATCHED THEN

UPATE ....

WHEN NOT MATCHED THEN
INSERT ...

;

/

I am using Oracle 10g.

Thanks

.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2013
Added on Oct 1 2013
4 comments
8,111 views