16.20 - Incremental Planning and Execution (IPE) Query Bands - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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.