17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

QryLogFeatureUseCountV provides use counts based on the current data in DBC.DBQLogTbl.

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.

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

Example: Using QryLogFeatureUseCountV

The example generates a report on feature usage.

SELECT cast(featurename as CHAR(50)) as FEATURENAME, FEATUREUSECOUNT 
FROM DBC.QryLogFeatureUseCountV order by 2 desc;

Result:

FEATURENAME                       FEATUREUSECOUNT
--------------------------------  ---------------
Block Level Compression                      8371
Primary Index                                8371
Hashed Table                                 8371
SET Table                                    7366
Non Unique Hashed Index                      6018
Fallback                                     3298
Unique Hashed Index                          3016
Parameterized Query                          1911
Partition Level Locking                      1659
Secondary Index                              1230
Teradata Stored Procedure                    1174
[...]
Autoreparse                                    15
User Defined Function                          11
Join Index                                      8
Bit Manipulation Function                       5
Fast Path Function                              5
MloadX                                          0
[...]