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–32768 |
|---|---|
| Default: | DISABLE |
| Update: | option 30 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM STARJOIN |
- DISABLE
- Star schema processing is disabled.
- ENABLE
- Star schema processing is enabled if the cardinality of the fact table is at least 25 times the cardinality of the largest dimension that is a base table that is joined to the fact table.
- 1
- Star schema processing is enabled. The single table with the largest cardinality is the fact table. However, if more than one table has this cardinality, star join is not enabled.
- 2–32768
- Star schema processing is enabled if the cardinality of the fact table is at least the specified number times the cardinality of the largest dimension that is a base table that is joined to the fact table.