Indexing

Databases (2): Indexing and Query Planning — How Databases Find Your Data

Deep dive into B-tree and B+tree indexes, hash indexes, composite indexes, covering indexes, and how to read EXPLAIN output to diagnose slow queries.