ColumnUseCountV[X] - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Category: Accounting

Database: DBC

View Column Data Type Format Description
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Database name of the object for which access count or UDI counts are recorded.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Name of the table whose column was accessed by a query.
FieldName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Field name of a table if usage type is a DML type; StatsId if the usage is for statistics (the optimizer usage of statistics).
UsageType CHAR(3) LATIN UPPERCASE NOT NULL X(3) The usage type of the object (DML or STA).
AccessCount BIGINT --,---,---,---,---,---,--9 Number of accesses since the last reset by the user.