16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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
[...]