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
Test for Scalability
You can test a single SQL or index-set alternative to find out how it will perform under different amounts of data in your database in Quest's Benchmark Factory program (version 4.6 or later).
To send SQL statement to Benchmark Factory
-
Click
to optimize the original SQL statement. The rewritten SQL versions display as alternatives in the Run Time pane..
- Click
to generate virtual index sets and add them as alternatives.
-
Click Test for Scalability
.
- Select the alternative you want to test.