Contains one row for each component of an index in the database. For an index with n components, there will be n rows in this table.

The following table provides details of the SYSINDEXES table.

Table 1. SYSINDEXES core system table
Column name Column data type Column size
abbreviate BIT 1
active BIT 1
creator VARCHAR 32
colname VARCHAR 32
desc VARCHAR 144
id INTEGER 4
idxcompress VARCHAR 1
idxmethod VARCHAR 2
idxname VARCHAR 32
idxorder CHARACTER 1
idxowner VARCHAR 32
idxsegid INTEGER 4
idxseq INTEGER 4
ixcol_user_misc VARCHAR 20
rssid INTEGER 4
tbl VARCHAR 32
tblowner VARCHAR 32