[T-SQL] Using specific index in SELECT clause

You can specify any index that you want to use explicitly in your SELECT clause after table name:

SELECT <column-names>
FROM <table-name> ( index = <index-name> )

This scheme is also called index hint.