1.7 Lab 2 Setup: Tuning Indexes for Specific Queries

Now let’s take the reverse problem: let’s start with nothing. We’ll drop all of the nonclustered indexes in our Stack Overflow database, then run the demo workload again. This time, we’re going to use sp_BlitzCache to list the most resource-intensive queries, look at Clippy’s index recommendations for them, and hand-craft our own indexes instead. Then,...