Share via


Maintenance Plan Wizard (Define Reorganize Index Task Page)

Use the Define Reorganize Index Task page to move index pages into a more efficient search order. This task uses the ALTER INDEX REORGANIZE statement with Microsoft SQL Server 2008 databases, and DBCC INDEXDEFRAG with SQL Server 2000 databases

Options

  • Databases
    Specify the databases affected by this task.

    • All databases

      Generate a maintenance plan that runs this task against all Microsoft SQL Server databases, except tempdb.

    • All system databases

      Generate a maintenance plan that runs this task against each of the SQL Server system databases except tempdb. No maintenance tasks are run against user-created databases.

    • All user databases

      Generate a maintenance plan that runs this task against all user-created databases. No maintenance tasks are run against the SQL Server system databases.

    • These specific databases

      Generate a maintenance plan that runs this task against only those databases that are selected. At least one database in the list must be selected if this option is chosen.

  • Object
    Limit the Selection grid to display tables, views, or both.

  • Selection
    Specify the tables or indexes affected by this task. Not available when Tables and Views is selected in the Object box.

  • Compact large objects
    Deallocate space for tables and views when possible. This option uses ALTER INDEX LOB_COMPACTION = ON.