Product has been added to your cart.

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.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Mastering Index Tuning
  7. 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.
Menu