The QryLogExplain[V] view is populated if the WITH EXPLAIN option is requested in addition to the information row. The following table describes the fields in QryLogExplain[V].
| QryLogExplain[V] Field | Description |
|---|---|
| CollectTimestamp | Time that the rows were written to the database. This field is also part of the multicolumn NUPI (also see ProcID). |
| ExplainText | Full Explain text segment. The text is not formatted and appears as a single long string. You may need to program a parsing application to look at the text. |
| ExpRowNo | Used if Explain text is greater than 31,000 characters and the system generates multiple rows. |
| ProcID | Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp). |
| 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.
|