SYSIQIDX System View

Presents group information from ISYSIQIDX in a readable format. Each row in the SYSIQIDX view describes an IQ index.

Note: This view replaces the deprecated system view SYSIQINDEX.

Column name	Column type	Description
table_id	unsigned int	The table number uniquely identifies the table to which this index applies
index_id	unsigned int	Each index for one particular table is assigned a unique index number
index_type	char(4)	Index type
index_owner	char(4)	Index owner
max_key	unsigned int	For internal use
identity_location	hs_vdorecid	For internal use
identity_size	unsigned int	For internal use
identity_location_size	unsigned int	For internal use
link_table_id	unsigned int	For internal use
link_index_id	unsigned int	For internal use
delimited_by	varchar(1024)	(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	unsigned int	(WD indexes only) Maximum word length for WD index

Constraints on underlying system table:

Primary key (table_id, index_id)

Foreign key (table_id, index_id) references SYS.ISYIDX

Foreign key (link_table_id, link_index_id, table_id, index_id) references SYS.ISYSIDX