Part 03 · Indexing
Clustered vs Non-clustered Indexes
Clustered indexSecondary indexHeap lookupIndex-organized table
InnoDB stores the row inside the primary key's tree, PostgreSQL keeps rows in the heap and points to them. What each costs on lookups, range scans and updates.
⏱ 6 min · Station 22 of 123