2.6 Designing Indexes for Queries Part 2 (26m)

Now that you’ve seen how we handle index design and building plans, let’s look at the index DMVs. You’ll learn why we say that the missing index DMVs and index usage DMVs are deceiving little liars. Then, you’ll be given a set of indexes, DMV contents, and queries, and you’ll design your own indexes. We’ll…