You can specify an index for each table in the FROM clause of a SELECT query. For example:
SELECT column_listFROM table_name [[ AS ]table_alias][ WITH (INDEX (index_val))]...WHERE ...
index_val is a string that indicates the name of the index.
If a candidate plan is generated with the specified index, the optimizer will use it. If the optimizer is unable to generate a candidate plan with the specified index, it ignores the hint.
