Microsoft SQL Server 2016: Managing Indexes and Statistics
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
By carefully managing aspects of your database like indexes and statistics, you are able to better tune performance and identify potential issues. This course teaches you about index management tasks, such as identifying and repairing fragmentation, identifying and creating missing indexes, identifying and dropping underused indexes, and managing existing columnstore indexes. In addition, this course covers statistic management topics, such as identifying and correcting outdated statistics, using Auto Update Statistics, and statistics for large tables. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience
Database administrators and database professionals
Prerequisites
None
Expected Duration (hours)
1.5
Lesson Objectives
Microsoft SQL Server 2016: Managing Indexes and Statistics
df_sqla_a09_it_enus
Expertise Level
Intermediate