FeatureNames_TBF | SQL Operators & User-Defined Functions | Teradata Vantage - FeatureNames_TBF - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
xwv1596137968859.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

Use the FeatureNames_TBF table function to perform an easy lookup when aggregating feature use counts.

Table function FeatureNames_TBF was added as part of the Feature Use Logging feature, and is created automatically. The table helps answer the following queries when joined with the DBC.DBQLogTbl.FeatureUsage column using BIT manipulation functions:
  • How many times was a particular feature used in the past week?
  • How many times was a feature used per day?
  • How many times was a feature used in a given period of time?
  • What is the most-used feature in Vantage?
  • What percentage of the requests used a certain feature?
  • When was the last time a particular feature was used?

For example, to find what percentage of the requests in DBC.DBQLogTbl use ‘Block Level Compression,’ use:

SELECT CAST((b.FeatureName as char(50)), cast( cast(NULLIFZERO(sum(GetBit(a.FeatureUsage,(2047 - b.FeatureBitpos)))) as FLOAT)/count(a.QueryID)*100 as FLOAT FORMAT '----,---,---,---,--9.999' ) as FeatureUsePercent  from DBC.dbqlogtbl a, DBC.QryLogFeatureListV b group by b.FeatureName where b.FeatureName = 'Block Level Compression';


FeatureName                                               FeatureUsePercent
-------------------------------------------------- ------------------------
Block Level Compression                                              65.164

To find the usage percentage of all the features, use:

SELECT CAST(b.FeatureName as char(50)), cast( cast(NULLIFZERO(sum(GetBit(a.FeatureUsage,(2047 - b.FeatureBitpos)))) as FLOAT)/count(a.QueryID)*100 as FLOAT FORMAT '----,---,---,---,--9.999' ) as FeatureUsePercent from DBC.dbqlogtbl a, DBC.QryLogFeatureListV b group by b.FeatureName order by 2 desc;

Syntax

[SYSLIB.] FeatureNames_TBF ()

Syntax Elements

SYSLIB.
Name of the database where the function is located.