17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

This view of DBQLXMLTbl shows query plans and statistics usage information in an XML document. These BEGIN QUERY LOGGING or REPLACE QUERY LOGGING options populate the QryLogXMLV view:

  • WITH XMLPLAN
  • WITH STATSUSAGE

Possible Values for HasXMLPlanData, HasStatsUsageData, HasVerboseData, and HasDetailedStatsData

For these columns, a value of Y or N can be specified. If you specify Y, the data is contained in the XMLTextInfo column on behalf of the specific logging [Option], where Option represents the STATSUSAGE or XMLPlan. If N is specified, the specific data (detailed statistics, statistics usage, VERBOSE EXPLAIN, and so on) is not stored in the XMLTextInfo column.

Possible Values for XMLDocType

Teradata recommends that you use the Has[Option]Data and [Option]Enabled columns rather than the XMLDocType column directly, where Option represents the STATSUSAGE or XMLPlan. Queries against these columns allow you to specify a Y or N value rather than bit mapped values. For more information about these columns, see "Possible Values for HasXMLPlanData, HasStatsUsageData, HasVerboseData, and HasDetailedStatsData" (above) or see "Possible Values for XMLPlanEnabled, StatsUsageEnabled, VerboseEnabled, and DetailedStatsEnabled" (below).

Possible Values for XMLPlanEnabled, StatsUsageEnabled, VerboseEnabled, and DetailedStatsEnabled

For these columns, a value of Y or N can be specified. If you specify Y, the [Option], where Option represents the STATSUSAGE or XMLPlan, was enabled when the data in XMLTextInfo was logged.

Possible Values for XMLDocType

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.

It is easier to use the [Option] Enabled and Has [Option] columns to see this information. Queries against these columns allow you to specify a Y or N value instead of bit-mapped values.

The XML DocType bit mask values are:

Value Description
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.