Optimizing SQL Server Statistics and Indexes

How should indexes be maintained? Do columnstore indexes need maintenance? What should I do about statistics? All those questions and more are answered in this course. See how to maintain your indexes to keep your database running smoothly.
Course info
Rating
(16)
Level
Advanced
Updated
Apr 8, 2020
Duration
1h 49m
Table of contents
Description
Course info
Rating
(16)
Level
Advanced
Updated
Apr 8, 2020
Duration
1h 49m
Description

Index maintenance is a complex topic, and one that's crucial for a well-performing database. In this course, Optimizing SQL Server Statistics and Indexes, you will learn foundational knowledge on how to keep your database and indexes well-maintained. First, you will explore missing and unused indexes, looking at how the indexes used by the system change over time. Next, you will discover why indexes, rowstore, and columnstore need maintenance and how to best perform that maintenance. Finally, you will learn how to perform statistics maintenance, allowing you to ensure that the Query Optimizer gets the information it needs to generate good execution plans. When you are finished with this course, you will have the skills and knowledge of index maintenance needed to keep your database running smoothly.

About the author
About the author

Gail Shaw is a Data Platform MVP and holds the MCM certification for SQL Server. Her specialties are in performance tuning and database recovery for SQL Server. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and often speaks at SQLBits and the PASS Community Summit.

More from the author
More courses by Gail Shaw
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name's Gil Shaw. Welcome to my course, optimizing Secret Service statistics and indexes. I'm a technical lead at intellect in Johannesburg, South Africa. In this course, we're going to have a look at why and how you should perform index and statistics maintenance and sequel server. Some of the things we will cover include creating and dropping indexes to keep up with a changing workload, roast or index fragmentation and how to handle it. Why Column Story indexes need maintenance and what options you have on what statistics are and why they need maintenance. By the end of this course, you'll be well versed on what you need to do to keep you indexes in order and your database performing well before starting the course you should be familiar with Secret Service Index is what they are and how they used. I hope you'll join me on this journey to learn more about indexes with the optimizing sequel service Statistics and indexes course applause