When to Index a Table: A Practical Guide for Analysts

Read the query plan, add the index, measure. 90.9 ms to 0.2 ms on half a million rows, the three ways to lose an index you already have, and the 7x it costs on writes.