立即与支持人员聊天
与支持团队交流

SQL Optimizer for SAP ASE 3.8 - Installation Guide

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

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级