How to hint the index to use in a MySQL select query? June 1, 2023 by Tarik You missed the FROM table Correct SQL should be: SELECT art.firma FROM your_table USE INDEX (i_iln) WHERE ....