Syntax Elements - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database
 

Syntax element …

Specifies …

STATIC

An EXPLAIN for the static plan is generated. If applicable, the static plan indicates the request is eligible for incremental planning and execution (IPE). By default, a static plan is generated unless the cost profile constant ExplainMode is changed to make the default DYNAMIC.

DYNAMIC

An EXPLAIN for the plan is generated. If the Optimizer determines that the request is:

  • Eligible for incremental planning and execution (IPE) and displaying a dynamic plan is allowed, a dynamic plan is returned. All of the plan fragments except the last one are executed to generate this dynamic plan. Values selected for intermediate results in a previous plan fragment can be masked with :* (colon asterisk) characters in subsequent plan fragments in the display, based on SecureExplain DBS Control field and Cost Profile constant settings.
  • Eligible for IPE, but the SecureExplain DBS Control field or Cost Profile constants are not set to allow returning a dynamic plan, a static plan is returned with an indication that the request is eligible for IPE.
  • Not eligible for IPE, a static plan is returned.
  • For information about DBS Control, see “DBS Control (dbscontrol)” in Utilities. Optimizer cost profile constants can override DBS Control settings. For information about setting cost profiles, see “CopyCostProfile,” “InsertConstantValue,” and “DeleteCostProfile” in Data Dictionary. The following Cost Profile constants apply to IPE:

  • IPEMinCostEstThreshold
  • IPEParsingPctThreshold
  • DynamicPlan
  • SpecificPlan
  • ExplainMode
  • The DynamicPlan and SpecificPlan query band settings can also determine when the Optimizer uses IPE. See “SET QUERY_BAND” in SQL Data Definition Language Detailed Topics and SQL Data Definition Language Syntax and Examples.

    IN XML

    Return the output as XML text rather than as plain English text. For more information, see SQL Data Definition Language.

    NO DDLTEXT

    Do not capture the DDL text in the XML EXPLAIN text.

    SQL_request

    Text of an SQL request about which Optimizer processing information is desired.