Positioning at start of table.
Positioning at end of table.
Positioning by Row IDentifier (RID).
Positioning by key.
Positioning at index start.
Positioning at index end.
These messages describe how access to a table or to the leaf level of an index takes place. The choices are:
Positioning at start of table.
Indicates a forward table scan, starting at the first row of the table.
Positioning at end of table.
Indicates a backward table scan, starting at the last row of the table.
Positioning by Row IDentifier (RID).
It is printed after the OR strategy has created a dynamic index of row IDs.
See “Dynamic index message (OR strategy)” for more information about how row IDs are used.
Positioning by key.
Indicates that the index is used to position the search at the first qualifying row. It is printed for:
Direct access an individual row in a point query
Range queries that perform matching scans of the leaf level of an index
Range queries that scan the data pages when there is a clustered index on an allpages-locked table
Indexed accesses to inner tables in joins
Positioning at index start. Positioning at index end.
These messages indicate a nonmatching index scan, used when the index covers the query. Matching scans are positioned by key.
Forward scans are positioned at the start of the index; backward scans are positioned at the end of the index.
