Difference between HASH JOIN And MERGE JOIN

Hash joing is implemented in CBO and comparatively faster.  Merge joing is comparatively slow because both the row sources are to be sorted before merging.
  • Interview Candidate
  • 1
  • 2968

Showing Answers 1 - 1 of 1 Answers

Sampath

  • Oct 22nd, 2005
 

Hash join occupies lots of memory as it creates hashes

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions