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.

Related topics

Creating and editing a What-If index scenario

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.

 

 

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

BMC AMI Command Center for Db2 13.2