CA IDMS/DB SQL Dictionary Reports—QREPORTS › QREPORT 007 -SQL Table Index Report › Field Descriptions

Field Descriptions

A description of the fields in QREPORT 007 follows:

SCHEMA NAME

The schema which owns the indexes listed as follows.

INDEX NAME

The name of the index that was created.

SCHEMA.TABLE

The schema and table name for which this index is defined.

INDEX COLUMNS

Specifies the column(s) used to create the index key.

ORDER

Indicates the sort order of the values in the named column(s), ascending or descending.

OTHER SPECIFICATIONS

Lists other specifications used to create the index, such as compressed/uncompressed, clustered, displacement.