OraFAQ Forum: Performance Tuning » Difference in location of the hint

Home » RDBMS Server » Performance Tuning » Difference in location of the hint

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference in location of the hint [message #163041]

Tue, 14 March 2006 13:55

a_developer
Messages: 194
Registered: January 2006

Senior Member

What is the difference between:

CREATE table table_A
PARALLEL (DEGREE 8)
as 
SELECT * FROM table_B;

and

CREATE table table_A
as 
SELECT /*+ PARALLEL (table_B, 8) */ 
       * 
FROM table_B;

If they're different, which is better??? Why??

Report message to a moderator

Re: Difference in location of the hint [message #163089 is a reply to message #163041]

Tue, 14 March 2006 21:49

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

In the first example, the table will be created so that future queries will use parallel query. In the second example, only the creation will use Parallel Query, queries on the created table will be serial.
_____________
Ross Leishman

Report message to a moderator

Re: Difference in location of the hint [message #163183 is a reply to message #163089]

Wed, 15 March 2006 06:45

a_developer
Messages: 194
Registered: January 2006

Senior Member

thanks again, Ross.. that was enlightening.

Report message to a moderator

Previous Topic:	Numeric or Alphanumeric datatype
Next Topic:	Oracle 8.1.7.0 - How to find BIND Variable values ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 08:03:55 CST 2024