To control how many memory map views are created to increase performance, set the following value:

 

JOINCACHEMULTIPLIER = 1

 

The total number of memory map views is log(#  of rows) * JOINCACHEMULTIPLIER.

Default = 3.

 

Environments: Client, Windows, Unix

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

Unix Registry Setting: CONNX.JOINCACHEMULTIPLIER