SQL Index Definition Fields
Field 1 - Index Name
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.
Field 2 - Created by SQL (Y/N)
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.
Field 3 - Index Type
0 System use.
2 Item-id index.
3 Ordinary Reality index (sorted index).
Field 4 - Allow duplicates
Y Allows multiple rows per column to have the same value.
N Disallows multiple rows per column from having the same value.
Field 5 - Column name(s)
Lists the columns that are indexed.
Field 6 - Collation(s)
References field 5, indicating whether each column is indexed in Ascending or Descending order.
Field 7 - Reality index name
Specifies the name of the underlying Reality index.