How to fix indexes using dbForge Studio for SQL Server

Last modified: October 1, 2024

dbForge Studio for SQL Server allows fixing indexes quickly and easily.

To fix indexes visually:

1. In the Index Manager document, navigate to the Action required section.

2. Select indexes you want to fix.

3. Click Fix. The fix results are shown in the Result column of the Action required section of the document.

Script generation

You can generate T-SQL and run it against database immediately, or save it for the future use.

1. In the Index Manager document, navigate to the Action required section.

2. Click Script Changes.

3. Select the action you what to do with the generated script from the drop-down list box:

• Copy the script to clipboard.
• Open the script in a new SQL window.