EXPLAIN Syntax | SQL Statements | Teradata Vantage - EXPLAIN Request Modifier Syntax - Teradata Vantage - Analytics Database

SQL Data Manipulation Language
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™
[ 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.