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…

To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Index Tuning, or log in if you already shelled out the cash.

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...
To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Index Tuning, or log in if you already shelled out the cash.
Menu