Drop Indexes
The Index Impact analysis first creates the indexes on your database. Then it retrieves the query plan for each SQL statement that you have selected for your analyzer. When you set up the individual scenarios, you determine if you would like the indexes dropped or to leave them on your database.
If you do not have the analysis process drop the indexes, you can drop them in any one of the following ways:
-
In the tree pane (left pane), right-click the scenario name and select Go To Drop Indexes.
-
When you close the Index Impact Analyzer window, you are prompted to drop the indexes. Click Yes.
-
In the tree pane (left pane), click the scenario name and select the Create/Drop Indexes button at the top of the right pane. Click
next to the Drop Indexes or Drop All Indexes pane.
You can make the changes permanent, in one of the following ways:
-
In the tree pane (left pane), right-click the scenario name and select Confirm Index Changes. Click Yes.
-
When you close the Configuration Analyzer window, you are prompted to rollback the changes. Click No.