Use a specified index
INDEXIMA allows you to select a specific index when issuing a query to test its efficiency.
The key words USE INDEX
is used when you want to select a specific index different from the default, as shown in the following examples:
CODE
SELECT p_day, p_month FROM my_test USE INDEX (my_test9);
SELECT * FROM my_test USE INDEX (my_test5);