Welcome to MSDN Blogs Sign in | Join | Help

July 2006 - Posts

Wednesday, July 26, 2006 11:34 AM

Nested Loops Join

SQL Server supports three physical join operators: nested loops join, merge join, and hash join. In this post, I’ll describe nested loops join (or NL join for short). The basic algorithm In its simplest form, a nested loops join compares each row from
Posted by craigfr | 18 Comments
Filed under:
Wednesday, July 19, 2006 11:41 AM

Introduction to Joins

Joins are one of the most important operations performed by a relational database system. An RDBMS uses joins to match rows from one table with rows from another table. For example, we can use joins to match sales with customers or books with authors.
Posted by craigfr | 8 Comments
Filed under:
Thursday, July 13, 2006 1:12 PM

Index Examples and Tradeoffs

The optimizer must choose an appropriate “access path” to read data from each table referenced in a query. The optimizer considers many factors when deciding which index to use, whether to do a scan or a seek, and whether to do a bookmark lookup. These
Posted by craigfr | 3 Comments
Filed under:
Friday, July 07, 2006 1:36 PM

Seek Predicates

Before SQL Server can perform an index seek, it must determine whether the keys of the index are suitable for evaluating a predicate in the query. Single column indexes Single column indexes are fairly straightforward. SQL Server can use single column
Posted by craigfr | 5 Comments
Filed under:
 
Page view tracker