Tchater maintenant avec le support
Tchattez avec un ingénieur du support

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

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation