The XMLPLAN option is particularly useful for diagnosing performance issues with requests. Logging query plans in XML format enables the analysis of problematic requests using Teradata Support tools.
This request logs the Optimizer request plans of all requests, including SQL DML and selected DDL statements, performed by user u1 as XML text in DBC.DBQLXMLTbl. Because the XML document contains the full SQL text, specify a LIMIT SQLTEXT value of 0 to avoid duplicate logging of the request text in DBC.DBQLogTbl:
BEGIN QUERY LOGGING WITH XMLPLAN LIMIT SQLTEXT=0 on u1;