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, ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
