To determine how much memory is used for keeping key data when performing in-memory binary searches.

 

JOINCACHESIZE = 32000000

 

Default = 16000000 (16 million)

 

Environments: Client, Windows, Unix

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

Unix Registry Setting: CONNX.JOINCACHESIZE