Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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:

    NewClassicDescription

    indicates an index that participates in the Explain plan

    indicates an index that has been dropped

    indicates an index that has been added

    indicates an index that has been edited


Was this page helpful? Yes No Submitting... Thank you

Comments