17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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.