Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for DB2 LUW 4.3.1 - Release Notes

Batch Termination

Batch Termination 

ClosedView the Batch Run Criteria Window—Batch Termination 

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 SQL and index-set alternatives that give you performance improvement without having to execute every alternative.

Tip: To save all settings on the Batch Run Criteria dialog for subsequent batch runs, select Save setting for the next batch run.

Batch Run Termination Criteria

Option

Description

No termination

Specify to run the Batch Run to completion.

Terminate Batch Run if the specified number of SQL/Index Sets falls in the criteria

Specify to terminate the Batch Run when a specified number of alternatives are found that meet the following requirements for terminating the Batch Run.

Number of SQL/Index Sets (excluding the Original)

Specify how many alternatives must be found that show performance improvement over the original SQL before the Batch Run will be terminated. 

Count the SQL/Index Sets if its elapsed time is faster than

Specify one of the following criteria to determine how the performance improvement is determined.

Original SQL

Count all alternatives that run faster than the elapsed run time from the original SQL.

Original SQL with a percentage of improvement

Count all alternatives where the elapsed run time for the alternative is the specified percentage faster than time for the original SQL statement.

User-defined time (mins/secs)

Count alternatives that run faster than a specified number of minutes and/or seconds.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation