In some situations, the
Reorganize Index task, coupled with the
Update Statistics task (covered in the next chapter), provides a useful alternative to the
Rebuild Index task. But before I go any further, let me state again, very clearly, that you should not run the
Reorganize Index task if you are running the
Rebuild Index task. These tasks perform essentially the same function, and there is no point in repeating the same step. Unfortunately, the Maintenance Plan Wizard is not smart enough to prevent you from making this mistake, and will let you create and schedule both of them.
Reorganize Index works to achieve essentially the same goal as the
Rebuild Index task, namely maintaining the health of your database ...