Transactions and Indexing
ACID properties, isolation levels, B-tree indexes, and how a query engine uses them.
Transactions protect data from partial failures and concurrent interference. This chapter covers atomicity, consistency, isolation, and durability; isolation levels and their trade-offs; and B-tree indexes — how they are structured, when the query planner uses them, and how to design indexes for common query patterns.