The Quick Reindex tool helps you quickly rebuild and reorganize SQL Server indexes. You can easily view the fragmentation level for all of the indexes on a SQL Server instance and then decide your course of action. You can filter the results by server, database, or table and sort indexes based on the fragmentation level, size, or name. To further help you analyze results, you can hide small or disabled indexes.
By default, Quick Reindex connects to the specified SQL Server instance using the credentials of your currently logged on Windows account, and then collects detailed information about the database indexes.
If an index shows a high fragmentation value after it is organized, verify the size of the index before continuing as small indexes often do not benefit from reorganization because fragmentation on small indexes is difficult to control. For more information, see Microsoft SQL Server Books Online.
The Online Rebuild and Max Degree of Parallelism options are only available on SQL Server Enterprise and Developer versions |
Idera Website | Products | Purchase | Support | Resources | Community | About Us | Legal |
---|