O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Rebuild Index Task

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:

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

An Overview of the Rebuild Index Task

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required