Nested Loops Showplan Operator

The Nested Loops operator performs the inner join, left outer join, left semi join, and left anti semi join logical operations.

Nested loops joins perform a search on the inner table for each row of the outer table, typically using an index. Microsoft SQL Server decides, based on anticipated costs, whether to sort the outer input in order to improve locality of the searches on the index over the inner input.

Any rows that satisfy the (optional) predicate in the Argument column are returned as applicable, based on the logical operation being performed.

Nested Loops is a physical operator.

Graphical execution plan icon:Nested loops operator icon

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

Logical and Physical Operators Reference
Understanding Nested Loops Joins
Using Inner Joins
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance