To setup and start the Batch Run
The Batch Run Criteria window is divided into the following tabs:
Select the batch run criteria.
The settings can be saved for next optimization by selecting the Save settings for next batch run checkbox. By default, this checkbox is unselected.
The Batch Run window displays the run-time criteria and posts the run time for each alternative as it is retrieved. Stop Current and Stop Batch Run functions are available to terminate the currently running alternative and to stop the Batch Run process. Each selected SQL statement is executed one by one, retrieving the run time unless it is terminated.
To terminate the complete batch run process
To terminate the current SQL statement
Select SQL | Stop Current.
When you log on to SQL Optimizer, it extracts the logical structure of the database, and maintains this connection throughout the application execution. Another database session is required for when executing the SQL statements for retrieve the run time. This connection is established when the Run for First Record, Run for All Records, or Batch Run functions are initiated and then this new session is dropped after the execution is complete.