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.
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 ...