The Smiling DBA
Archives: March 2012
Execution Plans – Merge Join
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
0 comments, 210 reads
Posted in The Smiling DBA on 15 March 2012
Execution Plans – Nested Loop
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
0 comments, 138 reads
Posted in The Smiling DBA on 9 March 2012



Subscribe to this blog