Presents group information from ISYSIQJOINIDX in a readable format. Each row in the SYSIQJOINIDX view describes an IQ join index.
This view replaces the deprecated system view SYSIQJOININDEX.
Column name |
Column type |
Description |
|---|---|---|
joinindex_id |
unsigned int |
Each join index is assigned a unique number that is the primary key. |
jvt_id |
unsigned int |
For internal use. |
dbspace_id |
smallint |
ID of the dbspace. |
joinindex_name |
char(128) |
Defines the name of the join index. |
joinindex_type |
char(12) |
For internal use. |
creator |
unsigned int |
The number of the user that created the join index. |
join_info_location |
hs_vdorecid |
For internal use. |
join_info_loc_size |
unsigned int |
For internal use. |
join_info_size |
unsigned int |
For internal use. |
block_map |
hs_blockmapidentity |
For internal use. |
block_map_size |
unsigned int |
For internal use. |
vdo |
hs_vdoidentity |
For internal use. |
vdo_size |
unsigned_int |
For internal use. |
commit_txn_id |
xact_id |
For internal use. |
txn_id |
xact_id |
For internal use. |
valid |
char(1) |
Indicates whether this join index needs to be synchronized. Y indicates that it does not require synchronization, N indicates that it does require synchronization. |
Constraints on underlying system table
Primary key (joinindex_id)
Foreign key (jvt_id) references SYS.ISYSTAB
Foreign key (dbspace_id) references SYS.ISYSDBSPACE
Foreign key (creator) references SYS.ISYSUSER
Unique (jvt_id, commit_txn_id, txn_id)
