[ STATIC | DYNAMIC ] EXPLAIN [ IN XML [NODDLTEXT] ] SQL_request [;]
Syntax Elements
- STATIC
- An EXPLAIN for the static plan is generated. This is the default. If applicable, the static plan indicates the request is eligible for incremental planning and execution (IPE).
- IN XML
- Return the output as XML text rather than as plain English text. For more information, see
Teradata Vantage™ - SQL Data Definition Language Detailed Topics
, B035-1184
.
- NO DDLTEXT
- Do not capture the DDL text in the XML EXPLAIN text.
-
SQL_request
- SQL request for which to return Optimizer processing information.