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