XML Plan Log Table: DBQLXMLTbl - Teradata Database

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” on page 380.

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:

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.

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.