The QryLogFeatureUseCountV view is populated if the WITH FEATUREINFO option for BEGIN/REPLACE QUERY LOGGING and this view (QryLogFeatureUseCountV) is included in a request. QryLogFeatureUseCountV provides a view into the FeatureUsage column of DBQLogTbl and the QryLogFeatureListV view.
The following table describes the fields in QryLogFeatureUseCountV.| QryLogFeatureUseCountV Field | Description |
|---|---|
| FeatureName | The name of the feature whose use is being counted. |
| Use Count | The number of times a feature is used by all the requests in DBC.DBQLogTbl. |
Specific and Generic Feature Names
The feature list includes specific feature names and, in certain cases, generic feature names. The generic feature name is logged when any of the corresponding specific feature names is logged. Not all specific features have a corresponding generic feature group. The following table is a partial list of specific feature names with corresponding generic feature names.
The list below is provided as an example of specific and generic feature grouping, but is not a complete list of features. The features list and the grouping of features is subject to change.
| Specific Feature Name | Generic Feature Name |
|---|---|
| 24 Teradata Columnar | 109 Column Partitioning |
| 27 Multi Level Partitioning | 26 Row Partitioning |
| 28 8 Byte Partitioning | |
| 29 2 Byte Partitioning | |
| 30 Column Partitioning and Row Partitioning | 26 Row Partitioning, 109 Column Partitioning |
| 31 Column-Partitioned and a NoPI | 109 Column Partitioning |
| 32 Column-Partitioned and a PI | |
| 33 Column-Partitioned and a PA | |
| 42 XML Data Type | 41 User Defined Type |
| 43 JSON Data Type | |
| 44 Distinct Data Type | |
| 45 Structure Data Type | |
| 46 Geospatial | |
| 47 3D Geospatial | |
| 48 Period Data Type | |
| 49 Array Data Type | |
| 50 Number Data Type | |
| 104 Aggregation Push for Union All | 110 Union All Pushdown |
| 105 Binary Join Push for Union All |