Indexes

Question 1

How do you force the system to use a specific index in a query?

Answer 1

use WITH (INDEX(IndexName)) :

SELECT col1 FROM Table1 WITH (INDEX(Index1))