Learn T-SQL Querying

NonClustered Index Seek

A NonClustered Index Seek operator represents a seek operation against a non-clustered index. This is also a non-blocking operator, and again is based mainly on the cost of I/O, requiring no additional memory or CPU. An index seek is a quick way to locate rows that match a predicate in the WHERE clause of a query, if the keys of the index match the predicate.

The following example shows a query executed in the AdventureWorks sample database with a NonClustered Index Seek:

SELECT LastName, FirstNameFROM Person.PersonWHERE LastName = N'Maxwell';

The query generates the following execution plan:

A NonClustered Index Seek ...