Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

Refresh SQL Query Plan

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

  1. Select the SQL.

  2. Select SQL | Refresh Plan or right-click the tree view and select Refresh Plan to open the Refresh Plan window.

  3. 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.

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

 

Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating