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

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 Operators and User-Defined Functions, 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 Examples: Using QryLogFeatureListV.

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