You can set query bands to specify when incremental planning and execution is used to generate a dynamic plan.
DynamicPlan Query Band
You can specify the following settings.
Value | Description |
---|---|
SYSTEM | The system determines whether:
This is the default. |
OFF | Generates a static plan. Incremental planning and execution (IPE) is not used and a dynamic plan is not generated. |
SpecificPlan Query Band
You can specify the following settings.
Value | Description |
---|---|
SYSTEM | For a parameterized query, the parameterized request cache (PRC) settings are used to determine whether a generic or specific plan is generated:
For a nonparameterized request:
This is the default. |
OFF | For a parameterized request, a generic plan is generated. This is a static plan. IPE is not used. For a nonparameterized request, a static plan is generated. IPE is not used.. |
ALWAYS | For a parameterized or nonparameterized request, a specific plan is generated and the DynamicPlan query band setting is used. |