2.3 Lab 3 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. To set up the lab, follow the same steps as Lab…