Analyzing SQL Indexes

This topic describes how to start analyzing SQL indexes with help of dbForge Studio for SQL Server.

To start analyzing indexes:

  1. In the Database menu, point to Tasks, and then click Manage Index Fragmentation. Alternatively, in Database Explorer, right-click a database or database instance, point to Tasks and then click Manage Index Fragmentation. The Index Manager document opens.
  2. Choose a Connection and a Database.
  3. Click Options to modify the default index fragmentation and index rebuild options.
  4. Click Reanalyze.

index manager