Example : Explain in XML
The query plan generated for the following request is captured and returned to the requestor as XML text:
EXPLAIN IN XML
SELECT *
FROM DBC.DBCInfoV;
Example : Explain in XML Without DDL-Related Text
The query plan generated for the following request is captured and returned to the requestor as XML text. Because the request specifies the NODDLTEXT option, all DDL‑related text is suppressed.
EXPLAIN IN XML NODDLTEXT
SELECT *
FROM DBC.DBCInfoV;
See the following for additional information about how to interpret the reports generated by an EXPLAIN request modifier or its related Visual Explain utility: