Maintaining Indexes - Microsoft SQL Server 2012 Performance Tuning - page 225

10

Maintaining Indexes

In this chapter we will cover:

F Finding fragmentation
F Playing with Fill Factor
F Enhancing index efficiency by using the REBUILD index
F Enhancing index efficiency by using the REORGANIZE index
F How to find missing indexes
F How to find unused indexes
F Enhancing performance by creating indexed views
F Enhancing performance by creating an index on Computed Columns
F Determining disk space consumed by indexes

Introduction

The duty of a DBA is not finished by just creating an index on necessary fields. Actually,
the DBA's duty of keeping database performance high starts at the point of creating a the
necessary index.

From time to time, the DBA needs to keep an eye on some very important points, mentioned
as follows, with regards to the index, because index maintenance is on-going task and needs
the attention of the DBA.

F Fragmentation level of index
F Missing index
F Unused index