Archives: March 2012
The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.
There is an interesting Clustered Index in the Adventure Works database. The SaleOrderDetail table’s primary key is a combination of the SalesOrderID and SalesOrderDetailID, not just the identity field of the… Read more
The nested loop is a physical operator used to join 2 or more sets of data when the query optimizer believes this is the best plan for the query.
The following query can be run against the AdventureWorks database:
SELECT cust.CustomerID, soh.SalesOrderID
FROM Sales.Customer cust
INNER JOIN Sales.SalesOrderHeader… Read more