Indexes Flashcards Preview

70-464 Certification > Indexes > Flashcards

Flashcards in Indexes Deck (1)
Loading flashcards...
1

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

use WITH (INDEX(IndexName)) :

SELECT col1 FROM Table1 WITH (INDEX(Index1))