Creating Indices on Allocation Manager Temporary Tables

Allocation Manager uses intermediate tables to temporarily store the results of an allocation calculation. When you perform allocations on large amounts of data, it is very important that indices are used correctly on all referenced temporary tables; this assures quality performance from the Allocation Manager. You should examine the indices on the temporary tables and ensure that they have been defined correctly, and are being used by the allocation SQL.

The intermediate tables used by Allocation Manager are:

• PF_AL_CALC_T

• PF_AL_DIFF_T

• PF_AL_DIV_T

• PF_AL_SRC01_T

• PF_AL_BAS02_T

• PF_AL_TOTAL_T

Due to platform limitation issues the prepackaged index is on the first 20 dimensions. Allocation Manager supports 30 dimensions. Depending on the number of dimensions you are using, modify the indices by adding the extra dimensions as keys, and rebuild the tables.