17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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