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

The QryLogFeatureListV view lists all the feature names that can be tracked when feature usage is enabled.

This view is populated whether or not the WITH FEATUREINFO option for BEGIN/REPLACE QUERY LOGGING is enabled. QryLogFeatureListV provides a view into the table function SYSLIB.FeatureNames_TBF. For more information about the table function, see Teradata® Vantage SQL Support for Database Administration, B035-1210.

Use this view to obtain the following information:
  • How many times a feature was used in a given period of time; for example, how many times a feature was used in a day or in the last week, and so on
  • List the most used feature in a release
  • List what percentage of the requests used a certain feature
  • List the last time a particular feature was used
The feature list is subject to change each Teradata release. To see the current list of features that are tracked, see Example: Using QryLogFeatureListV to List Features.

To enable feature use logging, see BEGIN QUERY LOGGING in Teradata® Vantage SQL Data Definition Language Syntax and Examples, B035-1144.