XML Plan Log Table: DBQLXMLTbl - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

This table stores query plans and statistics usage information in an XML document. These BEGIN QUERY LOGGING or REPLACE QUERY LOGGING options populate the table:


    DBC.DBQLXMLTbl Field



    Date and time that the rows were written to the database. This field is also part of the multicolumn NUPI (see also ProcID).

    For more information on CollectTimeStamp, see “Comparing CollectTimeStamp Value Between Tables” on page 380.


    Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).


    Internally generated unique identifier of the query.


    Describes the type of content stored in column XMLTextInfo. This column contains an encoded 32-bit integer value whose bit positions describe the type of data in the associated XML document stored in the XMLTextInfo column. The XML DocType bit mask values are:

  • 0x0000000001: XMLPLAN logging option was enabled
  • 0x0000000002: STATSUSAGE logging option was enabled
  • 0x0000010000: Data for XMLPLAN was logged
  • 0x0000020000: Data for STATSUSAGE was logged
  • 0x000000004: VERBOSE logging suboption was enabled
  • 0x000000008: DETAILED logging suboption was enabled
  • 0x0000040000: Data for VERBOSE was  logged
  • 0x0000080000: Data for DETAILED was logged
  • The DBC.QryLogXML[V] view shows the previous information with Y and N values. Accessing this information through DBC.QryLogXML[V] is recommended because it is easier to use.


    The row number in an XML query plan.


    Contains an XML document with the query plan and/or statistics usage information.

    Note: If the XMLTextInfo has more than one row per QueryID, use the QryLogXMLDocV view to see a single, readable document per QueryID. For more information, see “Improving XML Text Readability” on page 368.

    Note: The WITH ALL option does not log the query plan to DBQLXMLTbl.

    For information on how to store and retrieve XML data and how to perform XML operations such as validation, query, and transformation in Teradata Database, see Teradata XML.