Batch Termination
View Batch Run Criteria--Batch Termination Window
The Batch Termination page of the Batch Run Criteria window is used to determine if and when to terminate the Batch Run. It enables you to find alternative SQL statements that give you good performance improvement without having to execute every SQL alternative.
No termination
Specify to run the Batch Run to completion.
Terminate Batch Run if the specified number of index sets fall in the criteria.
Specify to terminate the Batch Run when a specified number of index set are found that meet the following requirements for terminating the Batch Run.
Number of index sets (excluding the Used Index)
Specify how many index sets must be found which show performance improvement over any index that is currently being used.
Count the index set if its elapsed time is faster than
Specify one of the following criteria to select how the performance improvement is determined.
Used Index
Count each index set where the run time for the SQL statement is faster than the time using the indexes currently on the database.
Used Index with a percentage of improvement
Count all index sets where the run time for the SQL statement is the specified percentage faster than the time using the indexes currently on the database.
User-defined time (mins/secs)
Count all index sets where the run time for the SQL statement is faster than a specified number of minutes and/or seconds.