An interactive simulator demonstrates how database indexes work by comparing full table scans versus index seeks. It explains B-tree structure, shows when to create indexes (WHERE clauses, JOINs, ORDER BY), covers different index types (single-column, composite, unique), and discusses trade-offs including storage overhead, Show more