Possibility to set USE/FORCE/IGNORE INDEX
peterpp opened this issue · 0 comments
peterpp commented
I have a big table with many records (millions). For some obscure reason, SQL database keep using wrong index, so selecting few rows takes 20 seconds instead of 9 ms. It would be very helpful, if there will be a possibility to set index hints:
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
For example:
SELECT *
FROM `big_table`
USE INDEX (my_better_index)
WHERE ...