title: How to use index in select statement?
body: <p>Lets say in the employee table, I have created an index(idx_name) on the <code>emp_name</code> column of the table.</p>
  
  <p>Do I need to explicitly specify the index name in select clause or it will automatically used to speed up queries.</p>
  
  <p>If it is required to be specified in the select clause, What is the syntax for using index in select query ?</p>