Maintain Indexes

Practice Labs Module
Time
30 minutes
Difficulty
Intermediate

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.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

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
Learning Partner
Comprehensive Learning

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