1.6 Lab 2 Setup: Adding Indexes with Clippy and the DMVs

Now that you understand how Clippy’s index recommendations are built, you’re better equipped to hand-craft your own missing index recommendation by taking his, and then thinking about what your queries are filtering for, and which columns are really going to reduce the search space.