15.10 - StatUseCountV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Accounting

DBC

 

View Column

Data Type

Format

Source Table.Column

DatabaseName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

Dbase.DatabaseName

TableName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

TVM.TVMName

StatName

VARCHAR(10000)

UNICODE

X(10000)

StatsTbl.StatName

AccessCount

BIGINT

--,---,---,---,---,---,--9

ObjectUsage.UserAccessCnt

The following SELECT statement shows the number of statistics accesses ocarina on a particular table:

SELECT StatName, AccessCount FROM DBC.StatUseCountV WHERE DatabaseName = 'Personnel' AND TableName = 'Employee';

The query returns the following result:

StatName  AccessCount
--------- ------------
ST1_id    10