Indexes aren't free

Every index speeds up some reads and slows down every write. I learned this the hard way when a table with eleven indexes started timing out on inserts. A short guide to reading query plans, spotting indexes nobody uses, and deciding which ones are actually worth their cost.