Set databases in SSMS
dbForge Index Manager is an intelligent SSMS add-in that helps users find indexes that require fragmentation and databases that need maintenance. The tool automatically defines indexes that can be rebuilt or reorganized based on the threshold criteria. Users can export index analysis results in a report or generate fix scripts for fragmented indexes.
Indexes can be managed in the Index Manager. To open it in SSMS, in Object Explorer, right-click the database to be analyzed and select Index Manager > Manage Index Fragmentation.
The Index Manager: [database_name] document opens where you can do the following: