nette/database

Possibility to set USE/FORCE/IGNORE INDEX

peterpp opened this issue · 0 comments

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 ...