Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Dropping an index from a What-If scenario

Use the following procedure to evaluate how dropping an index would affect the performance of a SQL statement.

To drop an index

New console
  1. Create a What-If scenario and select an index.For more information, see Creating-and-editing-a-What-If-index-scenario.
  2. Click Drop.The Indexes pane displays NW_minus_circle_red.png next to the dropped index.
  3. Click Generate explain plan NW_generate_explain.png to Explain the statement.
  4. ( optional ) Select an index and click Revert to return indexes that you have dropped.
Classic console
  1. Create a What-If scenario and select an index.For more information, see Creating-a-What-If-scenario.
  2. Click Drop.The Indexes pane displays Delete-16.png next to the dropped index.
  3. Click explain-24.png to Explain the statement.
  4. ( optional ) Select an index and click Revert to return indexes that you have dropped.


Where to go from here

Explain and compare the scenario 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*