Identifies the name of the index as it must be shown in an SQL query. Case is significant. Refer to the topic Naming Tables, Columns and Indexes.
Y Indicates that the index was created by an SQL Create-Index command.
N Indicates that the index was initially derived from a Reality file index.
0 System use.
2 Item-id index.
3 Ordinary Reality index (sorted index).
Y Allows multiple rows per column to have the same value.
N Disallows multiple rows per column from having the same value.
Lists the columns that are indexed.
References field 5, indicating whether each column is indexed in Ascending or Descending order.
Specifies the name of the underlying Reality index.