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.