How to Ensure that Databases Do Not Have Fragmented Indexes

Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes.

  • View the fragmentation level of indexes.Filter the results by
  • Filter the results by server, database, and table.
  • Sort indexes based on the fragmentation level, size, and name.
  • Hide small and disabled indexes.
  • Reorganize or rebuild indexes.

With the Quick Reindex tool of SQL Admin Toolset, quickly rebuild and reorganize indexes of databases on instances of SQL Server.

This is how easy it is:

  1. Connect to one or more instances.
  2. Display the statistics of the indexes of the databases.
  3. Filter the index view by database or table.
  4. Sort the indexes by selecting the relevant column header.
  5. Reorganize or rebuild one or more fragmented indexes.
  6. Specify the maximum number of processor cores for reindexing.
  7. Reindex the selected indexes offline or online.

Watch the video for more details: