Online Documentation for SQL Administrator for SQL Server
Rebuild/Reorganize Indexes Wizard
Rebuild/Reorganize Indexes Wizard allows you to perform index management operations in your SQL Server database: reorganizing, rebuilding, disabling (the ALTER INDEX REORGANIZE ... REBUILD ... DISABLE Transact-SQL statements are issued).
When indexes have pages in which the logical ordering based on the key value, does not match the physical ordering inside the data file, these indexes are called fragmented. Highly fragmented indexes may considerably decrease query performance. Index fragmentation is remedied by either reorganizing or by rebuilding an index.
To run the wizard select the Tools | 
Rebuild/Reorganize Indexes... main menu item or click Rebuild/Reorganize Indexes... button on the toolbar. Alternatively, you can right-click the database alias in the list of databases and select the Rebuild/Reorganize Indexes... item of the context menu.
The wizard consists of the following steps:
- Selecting server and databases
- Setting schedule options
- Setting reindex action condition
- Setting index actions and options
- Performing rebuilding/reorganizing
