Indexing for Performance: Query Strategies to Maximize Your SQL Server Indexes

SolarWinds sponsored on-demand webinar

Webcast Abstract

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:

1. The building blocks of index behavior, such as cardinality estimates, density, and statistical distribution
2. How to determine which indexes are used by a query by reviewing its execution plan and by querying important Dynamic Management Views (DMVs)
3. 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.