One missing index turned a 40ms query into a 12-second one

The query had run fine for two years. It joined orders to customers on a foreign key, filtered by...