feat: Add index hints (use, force, ignore) - Githubissues

Masterminds / squirrel

Fluent SQL generation for golang

Other

6.88k stars 465 forks source link

feat: Add index hints (use, force, ignore) #333

Closed Vesquen closed 9 months ago

Vesquen commented 2 years ago

Added following index hints:

USE INDEX
USE INDEX FOR JOIN
USE INDEX FOR ORDER BY
USE INDEX FOR GROUP BY
FORCE INDEX
FORCE INDEX FOR JOIN
FORCE INDEX FOR ORDER BY
FORCE INDEX FOR GROUP BY
IGNORE INDEX
IGNORE INDEX FOR JOIN
IGNORE INDEX FOR ORDER BY
IGNORE INDEX FOR GROUP BY

More info: https://dev.mysql.com/doc/refman/8.0/en/index-hints.html