Maintenance Plan Wizard (Define Reorganize Index Task Page)

  • Article

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

See Also

Other Resources

ALTER INDEX (Transact-SQL)
DBCC INDEXDEFRAG (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance