Analyzing SQL Indexes

This topic describes how to start analyzing SQL indexes with help of dbForge Index Manager.

To start analyzing indexes:

  1. In Object Explorer, right-click a database, point to Index Manager, and then click Show Index Manager. 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. For more information, refer to the Options Dialog Box topic.
  4. Click Reanalyze.

    Analyze Indexes