Most databases do have a way to force the index. See for example the MySQL way of doing it: <a href="https:&#x2F;&#x2F;dev.mysql.com&#x2F;doc&#x2F;refman&#x2F;5.5&#x2F;en&#x2F;index-hints.html" rel="nofollow">https:&#x2F;&#x2F;dev.mysql.com&#x2F;doc&#x2F;refman&#x2F;5.5&#x2F;en&#x2F;index-hints.html</a> . You probably already know this but I mention it in case someone else does not.