Chat now with support
Chat mit Support

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

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.

 

Modify SQL

You can only modify the SQL name and description of the SQL statements stored in the SQL Repository.

To modify the name or description

  1. From the SQL Repository window, select the SQL you want to modify from the left pane.

  2. Right-click and select Modify to open the Modify SQL window.

  3. Modify the name and/or description.  

Note: SQL text cannot be modified. You must delete the current SQL and recreating a new one to change the SQL text.

 

Rename SQL

You can rename a SQL statement stored in the SQL Repository window in two ways:

To rename a SQL statement

  1. Select the SQL you want to modify from the left pane.

  2. Right-click and select Rename. Change the name and press Enter.

    or

    Select Modify and change the name.

 

Delete SQL

When you delete a SQL statement in the SQL Repository, it will delete all references.

To delete a SQL statement stored in the SQL Repository

  1. Select the SQL you want to delete.

  2. Right-click and select Delete or press the Delete key to delete the selected SQL statement and all references to this SQL statement in other modules.

  3. If the SQL statement is in an Index Impact Analysis or an Index Usage Analysis, you will be prompted before it is deleted.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen