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

IndexName

VARCHAR(128)

UNICODE

X(128)

Indexes.Name

IndexNumber

SMALLINT

NOT NULL

---,--9

Indexes.IndexNumber

FieldName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

TVFields.FieldName

UsageType

CHAR(3) LATIN

NOT NULL

X(3)

ObjectUsage.UsageType

AccessCount

BIGINT

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

ObjectUsage.UserAccessCnt

Possible Values for IndexNumber

The IndexNumber is an internal number assigned to the index.

 

Value

Description

1

Primary index or primary AMP index

Multiple of 4 (that is, a number between 4 and 128)

Secondary index

Possible Values for UsageType

 

Name

Description

DML

Data Manipulation Language

STA

Optimizer usage of statistics

The following SELECT statement shows the number of index accesses occurring on a particular object:

SELECT IndexNumber, AccessCount FROM DBC.IndexUseCountV WHERE DatabaseName = 'Personnel' AND TableName = 'Employee';

Result:

IndexNumber                 AccessCount
-----------  --------------------------
          1                           1