Incremental Planning and Execution (IPE) Query Bands - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

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:
  • Incremental planning and execution (IPE) is used to generate a dynamic plan.
  • A static plan is generated and IPE is not used.

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 specific plan, the DynamicPlan query band setting is used.
  • For a generic plan, a static plan is generated. Incremental planning and execution (IPE) is not used.

For a nonparameterized request:

  • On the first submission, the DynamicPlan query band setting is used.
  • Subsequently, a static plan is generated. Incremental planning and execution (IPE) is not used. The PRC settings are used to determine whether to cache the plan or not.

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.