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

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Incremental Planning and Execution (IPE) Query Bands

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.

    SYSTEMX

    Ignores cost profile threshold constants and overrides the DynamicPlan cost profile constant.

    OFF

    Generates a static plan. Incremental planning and execution (IPE) is not used and a dynamic plan is not generated. This setting overrides the DynamicPlan cost profile constant.

    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. This setting overrides the setting for the cost profile constant SpecificPlan.

    ALWAYS

    For a parameterized or nonparameterized request, a specific plan is generated and the DynamicPlan query band setting is used. This setting overrides the setting for the cost profile constant SpecificPlan.