As you’ve been working through the labs, you’ve surely caught Clippy’s missing index hints in some of your execution plans. You might have even looked at some of them and thought, “Well, that last one made sense, but this one here – this seems totally different than what Brent is teaching me to make. Who’s…
7 SQL Server’s Built-In Index Recommendations
As you’ve been working through the labs, you’ve surely caught Clippy’s missing index hints in some of your execution plans. You might have even looked at some of them and thought, “Well, that last one made sense, but this one here – this seems totally different than what Brent is teaching me to make. Who’s…
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
- 3 Designing Indexes for ORDER BY
- 4 Lab: Indexing for WHERE + ORDER BY
- 5 Designing Indexes for JOINs
- 6 Lab – Indexing for Joins
- 8 Recap and Next Steps
- Bonus Lab – Getting Index Recommendations and Tuning Them