Home » RDBMS Server » Performance Tuning » parallel hint (10g)
icon8.gif  parallel hint [message #360005] Wed, 19 November 2008 03:32 Go to next message
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
Re: parallel hint [message #360009 is a reply to message #360005] Wed, 19 November 2008 03:41 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Read the OraFAQ Forum Guide before posting.
Previous Topic: Materialized View Refresh Performance
Next Topic: Querry performance
Goto Forum:
  


Current Time: Sun Dec 04 12:53:31 CST 2016

Total time taken to generate the page: 0.18324 seconds