MVCC

Explore how indexes, statistics, WAL, snapshots, and locks shape query behavior through SQLite examples and PostgreSQL concurrency mechanisms.