Buttons on the Indexes tab
The following buttons are available:
Adds an index to a What-If scenario
Build a copy of an existing index
Edits the attributes of an index
Drops an index
Reverts changes made for the selected index
Generates statements reflecting changes that you made to a What-If scenario
This command button is dimmed unless you made changes to the indexes.
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
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 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