Serial/Parallel compilation of plan in Sappcom in Sagent

This can be governed by two keys created inside "HKEY_LOCAL_MACHINE\SOFTWARE\Sagent\Datamart\PP". These are Sagent client side (32 bit) keys therefore if Sagent is installed on 64 bit machine, these should be set in "HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Sagent\Datamart\PP"

• Key Name: SappcomSerialize
• Key Name: MaxPlans

Both keys are of type 'DWORD':

• With SappcomSerialize = 0 or not defined, Sappcomm does concurrent plan compilation up to a maximum of 'MaxPlans' plans compiling concurrently.
• With SappcomSerialize = 1 or not defined, Sappcomm does fully serialized or Single plan compilation.