EN_PJSJ in macro DSN6SPRM

Specifies whether to enable dynamic index ANDing, which is also called pair-wise join processing, when star join processing is enabled on DB2®.

Valid values are ON and OFF. The default value is OFF, which means that dynamic index ANDing is disabled.

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.

Therefore, setting EN_PJSJ to ON can provide more flexibility with index design on star schema fact tables when multi-column index design makes it difficult to effectively exploit the star join access method.