What if I Don’t Have a Predicate on the Partitioning Key? (6 minutes)
Please purchase the course before starting the lesson.
What happens when I can't get partition elimination?
Why Table Partitioning Does Not Speed Up Query Performance – With One Exception (52 minutes)
Welcome
- Table Partitioning Is Often Misunderstood - An Analogy (5 minutes)
- Downloads: PDF of the Slides, Plus Scripts
Learn
- Partition Elimination (15 minutes)
- What if I Don't Have a Predicate on the Partitioning Key? (6 minutes)
- Why Partitioning Makes Some Queries Harder to Optimize (4 minutes)
- Where Partitioning Shines - and When It DOES Speed Up Queries! (15 minutes)
- Final Q&A: Partition Granularity, Insert Speed, Archiving Data to Slower Storage (7 minutes)
Quiz and survey
- Quiz Time!
- A Quick Course Survey