Session Details

Week 7

Session 20

Skim Ch. 15

Topics

1. Optimizing Query Performance
2. Analyzing Queries

Slides

1. QueryOpt
2. ExternalSort.mov (a 26MB movie)
3. For reference see also MS-Tuning-1,
4. MS-Tuning-2,
5. and 15-merge_join.avi (a 27 MB movie)