Nonclustered Index Scan Showplan Operator

The Index Scan operator retrieves all rows from the nonclustered index specified in the Argument column. If an optional WHERE:() predicate appears in the Argument column, only those rows that satisfy the predicate are returned.

If the Argument column must contain the ORDERED clause, the query processor has determined that the rows be returned in the order in which the nonclustered index has sorted them. If the ORDERED clause is not present, the storage engine searches the index in the optimal way, without necessarily sorting the output.

Index Scan is a logical and physical operator.

Nonclustered index scan operator iconGraphical execution plan icon

See Also


How to: Display an Actual Execution Plan


Logical and Physical Operators Reference
Creating Nonclustered Indexes
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Other Resources

SELECT (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance