QryLogFeatureUseJSON[V] provides a view into the FeatureUsage column of DBQLogTbl. This view uses the system function TD_SYSFNLIB.TD_DBQLFUL to convert the FeatureUsage bitmap column into a JSON document with a list of features used by particular requests. The names of the used features are shown in JSON format. For details on the system function TD_SYSFNLIB.TD_DBQLFUL, see SQL Functions, Operators, Expressions, and Predicates.
The following table describes the fields in QryLogFeatureUseJSON[V].| QryLogFeatureUseJSON[V] Field | Description |
|---|---|
| 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.
|
| FeatureUsage | List of the features used, in JSON format. |