Lets say in the employee table, I have created an index(idx_name) on the emp_name
column of the table.
Do I need to explicitly specify the index name in select clause or it will automatically used to speed up queries.
If it is required to be specified in the select clause, What is the syntax for using index in select query ?
See Question&Answers more detail:os