Dig into the plan and test a nonclustered index (11 minutes)

Please purchase the course before starting the lesson.

Now, let's dig into that execution plan for the baseline and see what's going on! Once we know the lay of the land, er, query plan, then it's time to test and see how much of a benefit a disk based rowstore nonclustered index will give us.

Back to: Indexing for Windowing Functions (45 minutes) > Let's Tune It