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