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: | option 19 on panel DSNTIPB |
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.