If you feel the query plan stored with the SQL statement in the SQL Repository does not represent the current indication of performance due to database changes, you can retrieve the current query plan from the database.
To refresh the query plan in the SQL Repository
Select the SQL.
Select SQL | Refresh Plan or right-click the tree view and select Refresh Plan to open the Refresh Plan window.
The original query plan displays on the left pane while the newly retrieved query plan is displayed on the right pane for comparison. You can view and analyze the newly retrieved query plan, abstract plan, and SQL classification before saving the new query plan with the SQL statement.
Click Save to replace the original query plan with the newly retrieved one.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
