The QryLogExplainDoc[V] view is populated if the WITH EXPLAIN option is requested in addition to the information row. QryLogExplainDoc[V] provides a view into DBQLExplainTbl that combines multiple rows of ExplainText with the same QueryID into a single ExplainTextDoc document.
The following table describes the fields in QryLogExplainDoc[V].
|ProcID||Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).|
|CollectTimestamp||Time that the rows were written to the database. This field is also part of the multicolumn NUPI (also see ProcID).|
|QueryID||Internally generated identifier of the query and the FK to other DBQL tables.
QueryID is a system-wide unique field; You can use QueryID to join DBQL tables or the DBC.TdwmExceptionLog table with DBQL tables without needing ProcID as an additional join field.
|ExplainTextDoc||ExplainTextDoc combines multiple ExplainText rows with the same QueryID into a single document as CLOB type.|