15.10 - UpdateUseCountV[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

ObjectName

VARCHAR(128)

NOT NULL

X(128)

TVM.TVMName

FieldName

VARCHAR(128)

NOT NULL

X(128)

TVFields.FieldName

UsageType

CHAR(3)

NOT NULL

X(3)

ObjectUsage.UsageType

UpdateCount

BIGINT

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

ObjectUsage.UserUpdateCnt

Possible Values for UsageType

 

Name

Description

DML

Data Manipulation Language

STA

Optimizer usage of statistics

The following SELECT statement displays the number of updates occurring on a particular object:

SELECT FieldName, UpdateCount FROM DBC.UpdateUseCountV WHERE DatabaseName = 'Personnel' AND ObjectName = 'Employee';

The query returns the following result:

FieldName  UpdateCount
---------- ------------
id         1
name       0