Overview

Introduction

The Maintain Indexes module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Explore Index Statistics and Rebuild/Reorganize indexes

Exercise 1 - Explore Index Statistics and Rebuild/Reorganize indexes

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Explore existing index statistics
  • Check the fragmentation of index on a table using SSMS
  • Identify unused index on a table
  • Rebuild an index
  • Reorganize an index

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.