ALTER VIEW "SYS"."SYSIQJOINIXTABLE" as select * from SYS.ISYSIQJOINIXTABLE
Presents group information from ISYSIQJOINIXTABLE in a readable format. Each row in the SYSIQJOINIXTABLE view describes an IQ join index.
Column name |
Column type |
Description |
|---|---|---|
table_id |
unsigned int |
Corresponds to a table value in SYSTAB that is included in a join operation. |
joinindex_id |
unsigned bigint |
Corresponds to a join index value in SYSIQJOINIDX. |
active |
unsigned int |
Defines the number of times the table is used in the join index. |
Constraints on underlying system table
Primary key (table_id, joinindex_id)
Foreign key (table_id) references SYS.ISYSTAB
Foreign key (joinindex_id) references SYS.ISYSIQJOINIDX
