1.2 The D.E.A.T.H. Method: Dedupe and Eliminate
When tuning indexes, I use the D.E.A.T.H. Method: Dedupe identical (and near-identical) indexes Eliminate indexes that aren’t getting used Add indexes that the DMVs recommend (but analyze them first) Tune queries individually to hand-craft better indexes Heaps generally need clustered indexes In this module, I explain why I start with the D/E/A steps, and then […]
To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.