Does that actually fail on an index missing?  The docs for FORCE INDEX say &quot;a table scan is used only if there is no way to use one of the named indexes to find rows in the table&quot;, which to me implies it&#x27;s more like <i>FORCEFULLY SUGGEST</i>.