Installation
Installation Requirements
Install or Upgrade SQL Optimizer
Silent Install of SQL Optimizer
Uninstall SQL Optimizer
Register SQL Optimizer
Configuration
Troubleshoot SQL Optimizer
"Failed to Connect to IBM DB2 LUW"
No Index Recommendations from IBM DB2 LUW
"Failed to initialize the application"
Copyright
SQL Repository Tutorial
The SQL Repository stores the SQL statements that are used in the analysis of database performance. These may be SQL statements that you have identified as critical to the performance of your database application.
Adding SQL to the SQL Repository
-
Click
.
- If no SQL exists in the SQL Repository, then the Add SQL window appears automatically. Otherwise, you can open the Add SQL window by clicking
button.
-
In the Add SQL window enter the SQL text in the SQL Information tab. Click OK.
-
The SQL syntax is checked and the access plan retrieved before adding a new node to the SQL tree view with the SQL name. Each SQL statement added to the SQL Repository contains an access plan, SQL classification type (Simple, Complex or Problematic), and the current connection information (login name, database alias, and schema). The access plan stored with the SQL statement is important as it indicates the current performance of the SQL.