StatementCount

Attributes

This parameter has the following attributes:

Usage

Specify a value to represent the number of distinct statement types. Specify a lower value to direct High-speed Apply Engine to perform more bind actions more frequently, with fewer distinct statement types in each bound package. For example, if your input includes a small number of distinct statement types, specify a lower value to make High-speed Apply Engine bind the statement types and execute them with static SQL sooner.

Consider the following points as you specify this parameter:

• The StatementCount parameter works with the StatementUsage and PackageUsage parameters to determine when to bind a package. For more information about using these parameters, see Using-BindTuning-parameters-for-performance.
• If an apply request includes a template file, High-speed Apply Engine counts the entries in the template file against your StatementCount value. Each entry in the template file counts as one occurrence of a distinct statement type.
• To force High-speed Apply Engine to use static SQL for all input statements, set this parameter to 1 and the Synchronous parameter to Yes. If you use this technique, ensure that the MaxPackages value is high enough to accommodate the total number of distinct statement types in your input file.