15.10 - Indexes Report Contents - Teradata Administrator

Teradata Administrator User Guide

prodname
Teradata Administrator
vrm_release
15.10
category
User Guide
featnum
B035-2502-035K

Note: The actual column headings are a function of the database itself.

 

Table 47: Indexes Report 

Field or Control

Description

Index Name

Name of the index.

Column Name

Name of each column.

Index Type

The type of index.

Unique Flag

Indication of whether the index is unique:

Y = index is unique

N = index is not unique

Index Number

Internal index number.

Column Position

Position of the column in the index (For a composite index, this would indicate the order of the column making up the index).

Access Count

Number of times the object was accessed since the counter was last reset.

Last Access

Date the object was last accessed.