SJTABLES in macro DSN6SPRM
Specifies whether Db2 enables star join processing.
| Acceptable values: | 0–32767 |
|---|---|
| Default: | 10 |
| DSNZPxxx: | DSN6SPRM SJTABLES |
| Security parameter: | No |
- 0
- Star join processing is considered for a query block that has 10 or more tables.
- 1–3
- Star join processing is always considered.
- 4–225
- Star join processing is considered for a query block that has at least the specified number of tables.
- 226–32767
- Star join processing is disabled.