60 minute session
Efficient Indexing Strategies
This session focuses on designing effective indexes within SQL Server. Attendees gain insight into how indexes contribute to performance, but also which considerations and trade-offs are involved. Because although indexes have a positive effect on queries that only read data, they have a negative effect the moment data is modified.
We start by discussing the various index types and their internal workings. Next, the focus is on practical guidelines for designing, analysing and maintaining indexes, so that attendees are better able to make well-considered choices in their database design.
Learning goals
- Understanding what indexes are and how they influence database performance
- Getting acquainted with different index types (clustered, nonclustered, columnstore, etc.)
- Gaining insight into the pros and cons of indexing (read vs. write impact)
- Understanding how index structures work internally
- Learning how to design an effective indexing strategy based on best practices
- Gaining insight into analysing index usage and identifying areas for improvement
- Understanding how index maintenance (such as rebuild and reorganize) contributes to performance
Level
Intermediate
Topics
Materials