Usage Notes - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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" or "Possible Values for XMLPlanEnabled, StatsUsageEnabled, VerboseEnabled, and DetailedStatsEnabled".

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.

Teradata recommends using 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.