posted 16 years ago
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!