SQL & PL/SQL

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 hint syntax

798489Mar 22 2013 — edited Mar 22 2013

Hi,

I have seen in several technical writings that the syntax for the USE_HASH hint is USE_HASH(TAB1, TAB2, ....) but nowhere in the oracle documentation it is specified this way. So I have two questions:

1. Does the use_hash hint really work if we include more than two tables inside the set of parentheses?
2. Should the syntax be USE_HASH(TAB1 TAB2) or USE_HASH(TAB1,TAB2)

Thanks in Advance,
Sathya

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2013

Added on Mar 22 2013

#11g, #performance, #query, #tuning

3 comments

10,072 views