Database Indexing & Query Performance

Why a query that was instant on 1,000 rows times out at 10 million, and how indexes, EXPLAIN plans, and fixing N+1 queries get your speed back.