Skip to Content

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 BMC Workbench 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 BMC Workbench 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*

BMC Workbench for DB2 12.1