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 means that the pages ...
Get Microsoft® SQL Server® 2012 Step by Step 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.
