Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Indexes tab

The Indexes tab lists indexes for all tables participating in the Explain plan. You can also use the Indexes tab to create What-If index scenarios. The tab is displayed only after the baseline statement is Explained.

Buttons on the Indexes tab

The following buttons are available:

 

Button

Description

Add

Adds an index to a What-If scenario

Copy

Build a copy of an existing index

Edit

Edits the attributes of an index

  • For an existing index, you can only edit the statistics.
  • For an added or copied index, you can edit all fields.

Drop

Drops an index

Revert

Reverts changes made for the selected index

  • If the selected index was added, the index is dropped.
  • If the selected index was dropped, the index is reinstated.

Generate

Generates statements reflecting changes that you made to a What-If scenario

This command button is dimmed unless you made changes to the indexes.

Note

The command buttons are available only:

  • For What-If index scenarios
     You cannot edit the columns or attributes of an existing index, but you can make changes to its statistics.
  • For unexplained statements
    After you have Explained a statement, the command buttons are dimmed.
  • If you have a license for BMC AMI SQL Performance for Db2

Panes

The Indexes tab has a Tables pane and an Indexes pane:

  • The Tables pane lists all tables that are referenced in the SQL statement.

  • The Indexes pane lists the indexes of the selected table (by default, the table shown at the top of the Tables pane).

    The following tables lists the icons used in the Indexes pane:

    New

    Classic

    Description

    NW_check_green.png

    g_gud_Check_16.png

    indicates an index that participates in the Explain plan

    NW_minus_circle_red.png

    Delete-16.png

    indicates an index that has been dropped

    NW_plus_circle_green.png

    Add-16.png

    indicates an index that has been added

    NW_pencil_adapt_teal.png

    edit-24.png

    indicates an index that has been edited

Related topic

Performance-perspective


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*