SYSIQJOINIXTABLE system view

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