HASH Joins

• David.Poole

  SSC Guru

  Points: 76191

  More actions

  March 31, 2004 at 7:39 am

  #163319

  When (if ever) would I use a HASH join and what exactly are the other exotic joins.

  • Hash?
  • Merge?
  • Loop?

  I tried playing around but got error 8622.

  LinkedIn Profile

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 31, 2004 at 8:39 am

  #501302

  Try this http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q197/2/97.ASP&NoWebContent=1

• Alamir

  SSCertifiable

  Points: 6085

  More actions

  April 6, 2004 at 4:49 am

  #501837

  I know that

  1- Loop is the worest (no Index key on any side of relationships)

  2- Merge is the best (Index is found on the 2 sides of the relationships)

  3- You can use Hash in a table hint (I don't know it advantage over Merge)

  I hope this help u

  
  Alamir Mohamed
  Alamir_mohamed@yahoo.com