| Use of double parallel hint [message #440469] |
Mon, 25 January 2010 02:29  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
