Online Documentation for SQL Administrator for SQL Server
Reorganize indexes
Use the Reorganize Index Task dialog to move index pages into a more efficient search order.
The General tab allows you to set common properties for this task. To set relationships between tasks use the Precedence constraints tab.
Name
Enter the reorganize indexes task name.
Enabled
Check this option to enable task execution.
Connection
Specify which server connection should be used for task execution. You can choose among existing connections or create a new one.
Database(s)
Use the drop-down list to specify which databases indexes will be rebuilt during the task execution.
- All databases
Generate a maintenance plan that runs maintenance tasks against all Microsoft SQL Server databases except tempdb.
- All system databases
Generate a maintenance plan that runs maintenance tasks 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 maintenance tasks against all user-created databases. No maintenance tasks are run against the SQL Server system databases.
If you choose Select databases... item or click the ellipsis 
button then define databases using the Select databases dialog.
Object(s)
If you have chosen a single database in the Database(s) field then you are to define the objects (tables or views) which indexes you want to be rebuilt. The drop-down menu contains the following items: All tables and views, All tables, All views, Select... .
If you choose the latter item or click the ellipsis button then define tables and views using the Select Tables/Views dialog.
Compact large object pages
Check this option to deallocate space for tables and views when possible.
See also:
