[ 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 Using BEGIN QUERY LOGGING to Log Query Plan Information.
- NO DDLTEXT
- Do not capture the DDL text in the XML EXPLAIN text.
- SQL_request
- SQL request for which to return Optimizer processing information.