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.