Why Your Database Index Gets Ignored (and How to Design One That Isn't)

A multi-column index in a database is ignored if the query filter doesn't start from the index's first column. To fix this, put the column you filter on first in the index. Additionally, consider creating a covering index that includes every column needed by the query to avoid additional table hops. However, be mindful that indexes can tax write operations.