Skip to Content

Editing an index for a What-if scenario

Use the following procedure to edit an index and evaluate the effect on the SQL statement's performance.

Warning

Important

You cannot edit the columns or attributes of an existing index, but you can make changes to its statistics.

To edit an index

  1. Select an index.For more information, see Adding-an-index-to-a-What-If-scenario.
  2. Click Edit.
  3. Complete the Index Attributes dialog box.For more information, see Adding-an-index-to-a-What-If-scenario.

Where to go from here

Explain and compare the statement after you have completed editing.

Related topic

Creating-and-editing-a-What-If-index-scenario


 

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

BMC AMI Command Center for Db2 13.1