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