Now, it’s your turn: take the below queries individually and design the right nonclustered indexes to make them dramatically faster. You’re going to be joining between the small Users table and a few larger tables, so if you haven’t created indexes on the larger tables before, be aware that index creation will take longer depending…
Now, it’s your turn: take the below queries individually and design the right nonclustered indexes to make them dramatically faster. You’re going to be joining between the small Users table and a few larger tables, so if you haven’t created indexes on the larger tables before, be aware that index creation will take longer depending...
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
- 7 SQL Server’s Built-In Index Recommendations
- 8 Recap and Next Steps
- Bonus Lab – Getting Index Recommendations and Tuning Them