You need to ensure your queries match your index, but when isn’t that true :)
When you write another query against that index a few weeks later and forget about the caveat, that slight change in where clause will ignore that index.
reply
You need to ensure your queries match your index, but when isn’t that true :)