×
 
 
  •  
$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')
BMC AMI Command Center for Db2 12.1 ... Using Tuning SQL Performance perspective

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
Related topic

Performance perspective


Was this page helpful? Yes No Submitting... Thank you
Last modified by Sarig Scudder on Jun 24, 2020
using

Comments

Log in or register to comment.

SQL tab
Explain tab
© Copyright 2013 - 2024 BMC Software, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2024 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.