Indexes Report Contents - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2502
lifecycle
previous
Product Category
Teradata Tools and Utilities

Indexes Report Contents

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.