Home » RDBMS Server » Performance Tuning » Use of double parallel hint
Use of double parallel hint [message #440469] Mon, 25 January 2010 02:29 Go to next message
sameertuladhar
Messages: 12
Registered: November 2008
Location: Nepal
Junior Member
Can we use two parallel hints in an insert statement when we are inserting data into two tables like the example :

INSERT /*+ PARALLEL(good,4), PARALLEL(bad,4) */ FIRST
WHEN
GENDER IN (''M'',''F'')
AND DOB IS NOT NULL
THEN
INTO good(MEMBER, GENDER, NAME)
VALUES(MEMBER, GENDER, NAME)
ELSE
INTO bad(MEMBER, GENDER, NAME)
VALUES(MEMBER, GENDER, NAME)
SELECT /*+ PARALLEL(A,8 ) */
MEMBER, GENDER, NAME
FROM
GENDER_DIST A

Regards,
Sameer.
Re: Use of double parallel hint [message #440480 is a reply to message #440469] Mon, 25 January 2010 02:58 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try it, get execution plan and you will see.

Regards
Michel
Previous Topic: Finding INSERT statments between 2 AWR snapshots
Next Topic: Query performance problem
Goto Forum:
  


Current Time: Sat Dec 10 17:01:33 CST 2016

Total time taken to generate the page: 0.03901 seconds