Domain

Indexes & Query Performance

How access paths, statistics, query shape, algorithms, and measurement combine to make database work fast and predictable.

1. Index Mental Model
2. B Tree Indexes
3. Non Btree Indexes
4. Composite Indexes
5. Covering And Index Only Scans
6. Partial Functional And Specialized Indexes
7. Selectivity Cardinality And Statistics
8. Sargability And Query Shape
9. Cost Based Query Planning
10. Join Sort And Aggregation Algorithms
11. Explain And Performance Methodology