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?