Can you force the database to use an index on a
query?
Generally, you will not tell the database when to actually use an index – that decision
will be made by the database itself. Although it is worth noting that in most databases
(like Oracle and MySQL), you can actually specify that you want the index to be used.