How it works
Why does it behave this way?
- 1
Why indexes exist
When is a separate index worth building, and what exactly do we trade?
- 2
Index anatomy
Which four independent choices define every index entry, and what single tension sits under all of them?
10 pages - 3
Key domains
Which single criterion decides whether a predicate can be pruned, and how does each key domain fare against it?
7 pages - 4
Approximation and lifecycle
How can the cost of building an index be deferred or shrunk?
3 pages