Incremental Planning and Execution (IPE) Query Bands - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics
Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
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.