- Indexes: purpose, types (focus on B-tree), when to create/drop
- Write trade-offs: index maintenance cost on INSERT/UPDATE/DELETE
- ACID properties: Atomicity, Consistency, Isolation, Durability
- Index examples:
SQL/indexing.sql
- SQL Indexes: https://www.sqltutorial.org/sql-index/
- ACID (Wikipedia): https://en.wikipedia.org/wiki/ACID