STAR JOIN QUERIES field (STARJOIN subsystem parameter)

The STARJOIN subsystem parameter specifies whether star join processing is to be enabled.

Acceptable values: DISABLE, ENABLE, 1 to 32768
Default: DISABLE
Update: Start of changeoption 19 on panel DSNTIPBEnd of change
DSNZPxxx: DSN6SPRM STARJOIN

A value of 1 indicates that the fact table will be the largest table in a star join query that does not have fact/dimension ratio checking. A value of 2 to 32768 indicates that DB2® should use the ratio of the star join table and the largest dimension table.