Just like designing indexes for WHERE, this is another topic that seems simple on the outside, but unravels quickly. If your query only has equality searches in the WHERE, then the ORDER BY fields can just get added right onto the index keys, in…order. (See what I did there?) But if your query has INequality…
3 Designing Indexes for ORDER BY
Just like designing indexes for WHERE, this is another topic that seems simple on the outside, but unravels quickly. If your query only has equality searches in the WHERE, then the ORDER BY fields can just get added right onto the index keys, in…order. (See what I did there?) But if your query has INequality…
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.
- 0 Prerequisites Before the Class
- 1 Designing Indexes for the WHERE Clause
- 2 Lab: Indexing for WHERE
- 4 Lab: Indexing for WHERE + ORDER BY
- 5 Designing Indexes for JOINs
- 6 Lab – Indexing for Joins
- 7 SQL Server’s Built-In Index Recommendations
- 8 Recap and Next Steps
- Bonus Lab – Getting Index Recommendations and Tuning Them