Missing Indexes (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Indexes

Missing indexes is a feature which helps you to improve the performance of your system. The Missing indexes functionality proposes you to create new indexes for improving the system in case they are needed.

To access Missing Indexes:

From Performance Node

Accessing Missing Indexes

  1. Open the Performance node of the tree.
  2. Select Missing Indexes node.

Adding Indexes

From the Missing Index you can create an Index with the information needed. For that:

  1. Double click in the Missing Index you want to create.
    OR
  2. Right-click and Create...
    It opens the Indexes Wizard (SQL Server) filled with the information from the selected Missing Index.

From Databases Node

Accessing Missing Indexes

  1. Open the Databases node of the tree.
  2. Open the database of the tree where you want to check if there are Missing Indexes.
  3. Select the Tables node in the tree.
  4. Open the Table Editor where you want to check if there are "Missing Indexes". See Opening an Object Editor.
  5. Select the Missing Indexes panel if enabled.

You can also access the Missing Indexes with the dedicated node under the Database node.

Adding Indexes

From the Missing Index panel you can create an Index with the information needed. For that:

  1. Double click in the Missing Index you want to create.
    OR
  2. Right-click and Create...
    It opens the Indexes Wizard (SQL Server) filled with the information from the selected Missing Index.

From Database Monitor

Accessing Missing Indexes

  1. Click Utilities > Database Monitor.
    The Database Monitor opens.
  2. Select the Missing Indexes tab.
    Missing Indexes are listed.

Adding Indexes

  1. Select one of the Missing Indexes.
    The query for creating the Index for the selected Missing Index is shown in the SQL Window if the SQL Toggle is selected.
  2. Click Create in the Database Monitor window.