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