How to use index in select statement

Question

Let's imagine I established an index (idx name) on the emp name column of the employee database. Does the index name have to be specified directly in the select clause or will it be used automatically to speed up queries?

What is the syntax for utilizing an index in a select query if it must be mentioned in the select clause?

Answer 1

Here is the syntax if you want to check the index to see if it functions:

SELECT *
FROM Table WITH(INDEX(Index_Name))

The WITH statement will force the index to be used.