MENU
Index Hint
| tbl_name [[AS] alias] [index_hint_list] | |
| index_hint_list: | index_hint [, index_hint] ... |
| index_hint: | USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | IGNORE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) | FORCE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) |
| index_list: | index_name [, index_name] ... |
| You can tell the optimizer how to choose indexes when performing a query. For example, SELECT * FROM t1 USE INDEX (c1,c2) WHERE c1=1; |
|
| Specifying an empty index_list for USE INDEX means ‘use no indexes’. | |