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
|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:
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.
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.