How to Tune Indexes with Execution Plans

Out of stock

Learn how to design the best indexes for your queries by interpreting SQL Server execution plans in this one day course.

Category:

Description

Out of stock

SQL Server asks for a lot of indexes — but it does NOT always ask for the right index! You need to know the essential principles of index design to create the best nonclustered index, filtered index, or indexed view to speed up your critical queries.

Work through a series of simple problems and solutions to learn how to create and tune disk-based, rowstore indexes. Learn how to choose the right key columns, when included columns help, when to use special indexes, and how to avoid workload-killing gotchas.

Throughout the course, you’ll learn to use query execution plans to decode how SQL Server is using your index, and whether or not changing the index is likely to make your query even faster. You will see how SQL Server 2016’s Query Store feature offers you new tools for improving your indexes, and how Query Store compares to index Dynamic Management Views.

Reviews

There are no reviews yet.

Be the first to review “How to Tune Indexes with Execution Plans”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.