Indexing

Same query, same code, a thousand times faster. How a B-tree index lets the database skip reading the whole table, what it costs you on writes, and how EXPLAIN tells you where one actually belongs.