Skip to Content

Copying an index for a What-If scenario

Use the following procedure to copy an index, edit it, and save it as a What-If index in a What-If scenario.

Related topics

Creating and editing a What-If index scenario

Comparing statements

To copy an index

  1. Create a What-If scenario and select an index. For more information, see Creating and editing a What-If index scenario.
  2. Click Copy.
  3. In the Index Attributes dialog box, change the name and edit any other index attributes. For more information, see Adding an index to a What-If scenario.
  4. Click Finish. The wizard closes, and the results pane shows the new index with NG_plus_circle_dgreen.png beside it.

Where to go from here

You can now Explain and compare the scenario 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