Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

USE_HASH vs Parallel Hints

542647Oct 25 2010 — edited Oct 25 2010

Hi,

I am working on performance of a query. The Earlier Query was using Parallel Hint with Degree 8 which was using lot of CPU utilization. Now I have replaced that with USE_HASH hint. Which one is more expensive. The Parallel Hint was there in 2 tables, but I have used USE_HASH hint on all 8 table which are there in From Clause.

Please tell me which one is expensive out of there 2?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2010

Added on Oct 25 2010

#general-database-discussions

3 comments

1,335 views