SYSIQINDEX system table

CREATE TABLE SYS.SYSIQINDEX (
	table_id	 UNSIGNED INT NOT NULL,
	index_id	 UNSIGNED INT NOT NULL,
	max_key UNSIGNED INT NOT NULL,
	identity_location BINARY(16) NOT NULL,
	identity_size UNSIGNED INT NOT NULL,
	identity_location_size UNSIGNED INT NOT NULL,
	link_table_id UNSIGNED INT NOT NULL,
	link_index_id UNSIGNED INT NOT NULL,
	delimited by				VARCHAR(1024),
	limit		UNSIGNED INT,
	PRIMARY KEY ( table_id, index_id )
)

Each index in the database is described by one row in SYSIQINDEX, which corresponds to an index in SYSINDEX.

table_id The table number uniquely identifies the table to which this index applies. It corresponds to the table_id column of SYSTABLE.

index_id Each index for one particular table is assigned a unique index number.

max_key For internal use.

identity_location For internal use.

identity_size For internal use.

identity_location_size For internal use.

link_table_id For internal use.

link_index_id For internal use.

delimited_by (WD indexes only.) List of separators used to parse a column’s string into the words to be stored in that column’s WD index.

limit (WD indexes only.) Maximum word length for WD index (between 1 and 255 bytes).