01 Designing Indexes for the WHERE Clause (35m)

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.

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":""}