Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4 - Release Notes

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

  1. Click to optimize the original SQL statement. The rewritten SQL versions display as alternatives in the Run Time pane..

  2. Click to generate virtual index sets and add them as alternatives.
  3. Click Test for Scalability image\B_TestForScalability.gif.

  4. Select the alternative you want to test.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating