Index : indexname
This message indicates that the query is using an index to retrieve the rows. The message includes the index name.
If the line above this message in the output is “Using Clustered Index,” the index is clustered; otherwise, the index is nonclustered.
The keys used to position the search are reported in the “Keys are...” message.
See “Keys message”.
This query illustrates the use of a nonclustered index to find and return rows:
select au_id, au_fname, au_lname from authors where au_fname = "Susan"
QUERY PLAN FOR STATEMENT 1 (at line 1). STEP 1 The type of query is SELECT. FROM TABLE authors Nested iteration. Index : au_names_ix Forward scan. Positioning by key. Keys are: au_fname ASC Using I/O Size 16 Kbytes for index leaf pages. With LRU Buffer Replacement Strategy for index leaf pages. Using I/O Size 2 Kbytes for data pages. With LRU Buffer Replacement Strategy for data pages.