In what way can we use an index in a select statement?

Question

Assume that in the employee table, I created an index(idx_name) on the emp_name column of the table.

Is there any need to explicitly specify the index name in the select clause or will it speed up the queries automatically? 

And If it is very necessary to be specified in the select clause then what will be the index for this?

Answer 1

Try out this syntax for testing the index:

SELECT * FROM Table WITH(INDEX(Index_Name))

The WITH statement will make the index to be used forcefully.

If you want to get more insights into SQL, check out this SQL Course from Intellipaat.