SUGANYA

• Jul 9th, 2006

 

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

partitions.

anu_dw

 Profile Answers by anu_dw Questions by anu_dw

• Sep 25th, 2006

 

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

pratyush

• Oct 22nd, 2006

 

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