Presents group information from ISYSIQIDX in a readable format. Each row in the SYSIQIDX view describes an IQ index.
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
