Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - Release Notes

Refresh SQL Access Plan

If you feel the access plan stored with the SQL statement in the SQL Repository does not represent the current performance due to database changes, you can retrieve the current access plan from the database.

To retrieve the current access plan

  1. From the SQL Repository window, select the SQL.

  2. Select SQL | Refresh Plan or right-click the SQL statement in the tree view and select Refresh Plan

  3. In the Refresh Plan window the original access plan is displayed on the left pane while the newly retrieved access plan is displayed on the right pane for comparison. You can view and analyze the newly retrieved access plan and SQL classification before saving the new access plan with the SQL statement.

  4. Click Save to replace the original access plan with the newly retrieved one.

 

Related Documents