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: 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: 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. |