Database Optimization: Performance and Scaling

Most database performance problems are query plans, not hardware. How to find them, what indexing really costs you, and when to scale up instead.