Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Parallel Hint! Very cool!

 
v ray
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi everyone,
was trying out parallel hints today to speed up query processing time, its unbelivable!
for example, there are currently more than 38 million records in a table(say table1) in our production database:

the query:
select count(*) from table1;

takes about 20-25 seconds to return the value.

however, if I use:

select /*+ Parallel */ count(*) from table1;

Guess!? Takes about 5 seconds! Thats just crazy!
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
this hint is useless without specifying the database type
 
v ray
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ah I am using oracle 10g.
 
S Venkatesh
Ranch Hand
Posts: 464
Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tuning Parallel

Please check this link. It's not as rosy as the results you show.
[ July 20, 2007: Message edited by: S Venkatesh ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic