Skip to main content

Clustered Index Seek

Short Description

Seek within a Clustered Index and return specified rows

Detailed Description

The Clustered Index Seek operator uses the seeking abilities of indexes to retrieve rows from a clustered index. The SEEK predicate 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