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.