Re: how to force index usage with a small local dev database

[Raf Mahn]

OK, so the only way is to rewrite the query to use force index?

The problem is, as part of out integration test suite(in java) I have automated tests which intercept all the sql calls and does an explain to assert that all the select sqls are using an index. Im trying to catch queries that don't use an index before they get to production and become a problem.

Sometimes the index is not being used, this is because there is too little data in the table(mysql runs in docker as restarts every now and then). This causes our tests to fail sometimes which is annoying.

So when mysql doesn't use an index Im trying to figure out a way to force mysql to use the index as it would in our production environment. Then if an index is not used then I can fail the test.