Did that Query Eliminate Partitions? (videos)

Table partitioning makes execution plans a bit more confusing

How much work did that query really have to do? It can be tricky to tell!

I have a new online course which walks you through decoding execution plans, including whether or not partition elimination occurred. In this first 10 minute video, I go over concepts for table partitioning and partitioned columnstore indexes:

Next up: partitioning demos

Get a real-live look at partition elimination in actual execution plans, cached execution plans, and Query Store in this 20 minute video:

Enroll in the course for free to get more videos and a desktop wallpaper

Enrollment is free for a limited time. You get access to all the videos and the course quiz through the end of the year, and you can download the course PDFs, desktop wallpaper, and demo scripts to keep learning and experimenting on your own.

Dive on it over at SQLWorkbooks.

2 Responses to Did that Query Eliminate Partitions? (videos)

  1. Srinivas August 16, 2017 at 7:37 am #

    Hi “Dear SQL DBA”

    I loved your above video. But somehow I was expecting to see the columnstore index being used. Am I missing something?

Leave a Reply