Chapter 21. Managing and maintaining indexes and statistics

After completing this chapter, you will be able to

  • Understand the difference between reorganizing indexes and rebuilding indexes.

  • Rebuild and reorganize indexes.

  • Check index fragmentations.

  • Defragment indexes.

  • Create and update database statistics.

Performance is typically measured by how fast data is returned from your database to applications, reports, and end users. While several other factors should be considered when evaluating performance, most users are concerned only with how fast the data is returned. As mentioned in Chapter 6, creating indexes can help improve database performance.

As the data in the database is manipulated, the indexes can become fragmented. This ...

Get Microsoft® SQL Server® 2012 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.