Hi friends i think there is no hash joins.We have hash

partitions.

The Hash join will be used if there are no adequate indexes on the joined columns. This is a worst situation. In this case hash table will be created. Hash join is most efficient when one of the tables is significantly differ in size than another one.

Regards

Anu

in cases where a very small table is being joind to large table the oracle hash join will often dramatically speedup the querry hash join are for faster than nested loops join same cashes.

regards pratyush singh