Lesson 3 — Disk I/O and Access Patterns

Topics

• Understand how disk I/O affects database latency
• Distinguish sequential reads from random reads
• Relate table scans, index scans, and heap access to disk work
• Understand the role of the OS page cache in query performance
• Recognize when a workload is I/O-bound rather than CPU-bound
• Use Bloom filters as a probabilistic pre-filter for reducing unnecessary reads

This lesson is finished