Database Performance for Developers: Indexing, Query Plans, and the Queries That Don't Scale

How database indexes actually work: B-trees, selectivity, composite indexes, covering indexes, and...