2.4 The D.E.A.T.H. Method – Heaps and Clustered Indexes
In most cases, when you tune an existing database, it’ll already have clustered indexes. However, we need to talk about what happens when it doesn’t: should you design a clustered index for it, or leave it as a heap? This lecture & demos explains the problems with wide clustering keys, show why IDENTITY fields are […]
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.