Online Documentation for SQL Administrator for SQL Server
Rebuild indexes
Use the Rebuild Index Task dialog to re-create the indexes on the tables in the database with a new fill factor.
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 rebuild 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.
Use fill factor value that is specified for rebuilt index
Drop the indexes on the tables in the database and re-create them with the fill factor that was specified when the indexes were created.
Use this fill factor value
Drop the indexes on the tables in the database and re-create them with a new, automatically calculated fill factor, thereby reserving the specified amount of free space on the index pages. The higher the percentage, the more free space is reserved on the index pages, and the larger the index grows. Valid values are from 0 to 100.
Sort in tempdb
This option determines where the intermediate sort results, generated during index creation, are temporarily stored.
Keep indexes online during rebuilding
This option allows users to access the underlying table or clustered index data and any associated nonclustered indexes during index operations.
See also:
