Home » RDBMS Server » Performance Tuning » Difference in location of the hint
Difference in location of the hint [message #163041] Tue, 14 March 2006 13:55 Go to next message
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??
Re: Difference in location of the hint [message #163089 is a reply to message #163041] Tue, 14 March 2006 21:49 Go to previous messageGo to next message
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
Re: Difference in location of the hint [message #163183 is a reply to message #163089] Wed, 15 March 2006 06:45 Go to previous message
a_developer
Messages: 194
Registered: January 2006
Senior Member
thanks again, Ross.. that was enlightening.
Previous Topic: Numeric or Alphanumeric datatype
Next Topic: Oracle 8.1.7.0 - How to find BIND Variable values ?
Goto Forum:
  


Current Time: Thu Mar 28 07:15:03 CDT 2024