 parallel hint [message #360005] |
Wed, 19 November 2008 03:32  |
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
|
Member |
|
|
hi,
i have to insert values into a table from another.
I used query like:
----------------------------------------------------------------
INSERT /*+ APPEND PARALLEL(z,4) */ INTO ABC z
(
..,..,..,..)
SELECT
'||vblMaxSN||' + ROWNUM AS SN,
b.*
FROM
(SELECT /*+ parallel(b,4) */
..,..,..,.. FROM CDE) b
-----------------------------------------------------------
i need to know whether i should use parallel hint in outer select statement or inner one. or i can use it in both the select statements.
thankx
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
