Foundation for understanding COMMIT, ROLLBACK, and transaction boundaries. - **Chapter 15: Buffer Pool Tuning** — Lock memory (LOCKLIST) competes with buffer pool memory for system resources. - **Chapter 17: Indexing Strategies** — Good indexes reduce the number of rows examined, directly reducing l