This chapter will describe how to use the
Rebuild Index task in the Database Maintenance Wizard to maintain the health of your database indexes which, in turn, can boost the performance of your queries. It will cover:
Rebuild Index does and the problems that can arise if it is not used
considerations when using the task, and possible alternatives
how to configure and schedule the task using the Wizard.
You will recall from Chapter 2 that, as indexes are subjected to data modifications, index fragmentation can occur in the form of gaps in data pages, which creates wasted empty space, and logical fragmentation, a logical ordering of the data that no longer matches its physical ordering. ...