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 | iconTools_IndexManagement Indices Management... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | iconTools_IndexManagement Indices Management... item of the context menu.








Full version (for Windows)


Lite version (for Windows)


Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.