SQL Server Physical Joins

The SQL Server physical joins are:

  1. Nested Loops Join

  2. Merge Join

  3. Hash Join

Here is a good link which explains each of them in brief.

http://www.mssqltips.com/sqlservertip/2115/understanding-sql-server-physical-joins/

 

Advertisements