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.

4 Comments. Leave new

Share a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: