QryLogExplainDocV provides a view into DBQLExplainTbl that combines multiple rows of ExplainText with the same QueryID into a single ExplainTextDoc document.
The QryLogExplainDocV view is populated if you request WITH EXPLAIN and the information row.
Referenced Columns
Data Dictionary view columns may have referenced table columns. That is, the value in the view column corresponds to a value in the selected column referenced in the table. Join the view and the referenced table based on the selected column and the referenced column.
Referenced columns for this view are:
| View Column | Description |
|---|---|
| QueryID | 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. |