• 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 ]
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!