O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Maintaining Indexes

In this chapter we will cover:

  • Finding fragmentation
  • Playing with Fill Factor
  • Enhancing index efficiency by using the REBUILD index
  • Enhancing index efficiency by using the REORGANIZE index
  • How to find missing indexes
  • How to find unused indexes
  • Enhancing performance by creating indexed views
  • Enhancing performance by creating an index on Computed Columns
  • 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required