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.

Related topics

Creating and editing a What-If index scenario

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.

 

 

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