The Scenario can be re-executed using the same indexes. You can choose to retrieve the access plans for all SQL statements in the Scenario or select specific SQL to retrieve the access plan again using the same indexes.
The function is useful if changes have occurred in the database environment, such as data volume changes, that may affect access plans.
To regenerate the access plan
Select the Scenario from the left pane.
Right-click and select Regenerate.
Check the SQL statements whose current access plans you would like retrieved again.
You can rename an analysis in the Index Impact Analyzer window in two ways.
To rename an Analyzer
Select the Analysis you want to modify from the left pane.
Right-click and select Rename. Change the name and press Enter.
or
Select Modify and change the name.
To delete an analysis
In the Index Impact Analyzer window, select the analysis you want to delete in the left pane.
Right-click and select Delete.
Below is a list of available functions within the Index Impact Analyzer window.
Button or Menu |
Function |
---|---|
Analysis & Right-click Menu
|
|
Right-click Menu |
Add Folder |
Right-click Menu |
|
Right-click Menu |
|
Right-click Menu |
|
Right-click Menu |
|
Right-click Menu |
|
Right-click Menu |
|
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center