16.10 - XML Plan Log Table: DBQLXMLTbl - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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:

  • WITH XMLPLAN
  • WITH STATSUSAGE
DBC.DBQLXMLTbl Field Description
CollectTimeStamp 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.

ProcID Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).
QueryID Internally generated unique identifier of the query.
XMLDocType 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.

XMLRowNo The row number in an XML query plan.
XMLTextInfo Contains an XML document with the query plan and/or statistics usage information.
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.
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.