MySql force index

Sometimes mysql may not use the index you created for some reason. To force mysql to use an index you can use FORCE INDEX.

| FORCE {INDEX|KEY} 

[FOR {JOIN|ORDER BY|GROUP BY}] (index_list)

Example:

SELECT * FROM table1 LEFT JOIN table2 FORCE INDEX FOR JOIN (`PRIMARY`) on table1.id = table2.id ...