Index name message

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.