16.10 - Feature Use Count View: QryLogFeatureUseCountV - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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