Clustered index
Primary key = index. Row data lives in leaves. Secondary indexes → PK → data. Different from PostgreSQL heap.
Advertisement
Redo log
Similar to WAL. Ensures durability. Written before data pages. Recovery replays.
Advertisement
Undo log
Old row versions for MVCC + rollback. Grows during long transactions. Cleaned by purge thread.