Online Documentation for SQL Manager for SQL server
Manage indices
Indices Management 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 Services | 
Indices Management... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | Indices Management... item of the context menu.
- Selecting database for indices management
- Selecting tables that contain indexes
- Specifying actions and setting options
- Editing and executing the result script
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |
