DB INDEXES DO NOT MAGICALLY COMPOSE

Summary from the TLDR Web Dev newsletter

Database indexes are similar to organized lists that help you find information quickly. To be most effective, indexes should align closely with how you typically query your data. Indexes don't magically work well at random and take careful thought to get correct.