Database Indexes That Actually Help (and the Ones Quietly Hurting You)
Most slow-query problems are not a missing index, they are the wrong index, or ten indexes nobody needs. Start from the query plan, build the index the query actually wants, and drop the ones taxing every write.