Indexing for Performance: Query Strategies to Maximize Your SQL Server Indexes
SolarWinds sponsored on-demand webinar
Few things influence the speed and performance of SQL statements within SQL Server® as much as indexes. This session will help you understand the basics of query performance in relation to the indexes on your production database. We'll teach you how to determine whether you're using good index strategies and the direct impact your indexing strategy has on queries.
Using a variety of examples, we'll show you how indexes can affect query performance, and a variety of best practices and ways queries can be written to maximize indexes in place. In this session, you'll learn things like:
- The building blocks of index behavior, such as cardinality estimates, density, and statistical distribution
- How to determine which indexes are used by a query by reviewing its execution plan and by querying important Dynamic Management Views (DMVs)
- A variety of query patterns and best practices to ensure optimal index usage
Prerequisites: Beginning SQL query writing skills. Basic understanding of indexes in a relational database.
Speaker - Kevin Kline and Thomas LaRock
To access materials please fill out the form below.