Product has been added to your cart.

1 Designing Indexes for the WHERE Clause

It sounds easy at first: just look at the list of fields in the WHERE clause, and put them in the index keys. But what order should you put them in? There’s a common misconception that the most selective (or unique) fields should go first. For example, if you have a column with a million…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of Index Tuning, or log in if you already shelled out the cash.

  1. Home
  3. Live Instructor-Led SQL Server Training Classes
  5. Fundamentals of Index Tuning (Instant Replay)
  7. 1 Designing Indexes for the WHERE Clause
It sounds easy at first: just look at the list of fields in the WHERE clause, and put them in the index keys. But what order should you put them in? There’s a common misconception that the most selective (or unique) fields should go first. For example, if you have a column with a million...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of Index Tuning, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}