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

  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.


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*