Skip to main content
Skip table of contents

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:

SELECT p_day, p_month FROM my_test USE INDEX (my_test9); 
SELECT * FROM my_test USE INDEX (my_test5);
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.