Skip to main content

Index Seek

Short Description

Index Seek retrieves rows from a nonclustered index.

Detailed Description

The Index Seek operator uses the structure of a nonclustered index to retrieve either single rows or a subset of rows. The SEEK operator positions the start of the retrieval, and an optional WHERE predicate allows rows to be filtered further. If the step is passed the ORDERED clause, the rows will be returned in index sorted order. If the ORDERED clause is missing, rows will be returned in the most efficient way which may not by in sorted order.

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.

DBmarlin Trial