Test for Scalability
You can test a single SQL statement 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:
-
Optimize the original SQL statement.
-
Select the original or one of the SQL alternatives
-
Click
.