How to read MySQL's EXPLAIN: possible_keys, key, Extra and the column order of an index
What took me years to learn to read in MySQL's EXPLAIN: why an index in possible_keys doesn't mean it gets used, what the Extra column warns you about and why a three-column index doesn't serve just any WHERE. With a table of 200,000 orders and the real plans.