StatementUsage
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [BindTuning] |
Abbreviation | None |
Required? | No |
Valid values | An integer from 1 to 32767 |
Default value | 200 |
Usage
Specify a value to represent the number of dynamic execution attempts. (High-speed Apply Engine executes statement types in an unbound package dynamically.)
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 many repeated statements of the same statement type, specify a lower value to make High-speed Apply Engine bind that statement type and execute it with static SQL sooner.
The StatementUsage parameter works with the StatementCount and PackageUsage parameters to determine when to bind a package. Adjust the value of this parameter to expedite or delay the binding of a package. For more information about using these parameters, see Using-BindTuning-parameters-for-performance.