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.