The SQL Information page of the Add SQL wizard is where you can enter the SQL text and view information about the SQL statement, such as the access plans and temp table DDL.
Enter the SQL text.
The SQL Information pane has buttons at the top of it to select whether to display the access plan graph, access plan tree, Information (the classification of the SQL), and the DDL for creating any temporary tables used by the SQL statement. If the button is enabled, there is information on that page. If the button is , then no information is available for that SQL statement.
Checks the SQL syntax using the current database connection and retrieves the access plan, SQL type classification, and other information relating to the SQL statement.
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
From the SQL Repository window, select the SQL.
Select SQL | Refresh Plan or right-click the SQL statement in the tree view and select Refresh Plan
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.
Click Save to replace the original access plan with the newly retrieved one.
You can only modify the SQL name and description of the SQL statements stored in the SQL Repository.
To modify the name or description
From the SQL Repository window, select the SQL you want to modify from the left pane.
Right-click and select Modify to open the Modify SQL window.
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.
To rename a SQL statement
Select the SQL you want to modify from the left pane.
Right-click and select Rename. Change the name and press Enter.
Select Modify and change the name.