Now, it’s your turn: in the Stack Overflow database (any size is fine, including the small 10GB one), take the below queries individually and design the right nonclustered indexes to make them dramatically faster. As you work through the list: Try different combinations of key and include fields for each query Use index hints to measure…
2 Lab: Indexing for WHERE
Now, it’s your turn: in the Stack Overflow database (any size is fine, including the small 10GB one), take the below queries individually and design the right nonclustered indexes to make them dramatically faster. As you work through the list: Try different combinations of key and include fields for each query Use index hints to measure…
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
- 3 Designing Indexes for ORDER BY
- 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