3.1 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 Live Class Season Pass, Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

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 Live Class Season Pass, Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Menu