To configure the CONNX join count, which determines the number of keys to use in a single pass when performing joins, set the following value:

 

JoinCount=nnn 

 

Default = 250 (maximum value).

When using Rdb 6.x, the recommended setting is 8.

 

Environments: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  JoinCount

Unix Registry Setting: CONNX.JOINCOUNT