- Course
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.
Advanced
- Course
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.
Advanced
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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.
Optimizing SQL Server Statistics and Indexes
Advanced
Table of contents
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.