EN_PJSJ in macro DSN6SPRM
Disables or enables dynamic index ANDing, which is also called pair-wise join processing, when star-join processing is enabled on Db2.
| Acceptable values: | OFF, ON |
|---|---|
| Default: | OFF |
| DSNZPxxx: | DSN6SPRM EN_PJSJ |
| Security parameter: | No |
- OFF
- Dynamic index ANDing is disabled.
- ON
- Dynamic index ANDing is enabled.
When dynamic index ANDing is enabled, it can improve the execution performance of qualified queries in the following cases:
- The fact table has indexes that provide matching for join predicates with some dimension tables having local filtering. The indexes on the fact table can be single-key indexes (but not limited).
- No multi-column index on the fact table is suitable for the existing star join method.
Setting EN_PJSJ to ON might provide more flexibility with index design on star schema fact tables when multi-column index design makes effective exploitation the star join access method difficult.