How can I enforce to use particular index? Answer:
You can use index hint (index=<index_name>) after the table name.
This is the example to use the aunmind index to get the last names
of each author from the authors table:
USE pubs
SELECT au_lname FROM authors (index=aunmind)