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

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

Answer Question  Select Best Answer