Administration Guide › Reports › Database Reports › Table Indexes

Table Indexes

The Table Indexes report lists all CA Business Service Insight tables with corresponding indexes and includes the following columns:

Note: This report requires Oracle sys permissions.

TABLE_NAME

The table name.

INDEX_NAME

The name of the index column.

INDEX_TYPE

The index type.

UNIQUENESS

Indicates if the index is unique.

COLUMN_POSITION

Indicates the order of the index positioning.

COLUMN_NAME

Lists the name of the column by which the index is ordered.