Increasing the number of partitions or partition points increases the number of threads. Therefore, increasing the number of partitions or partition points also increases the load on the node. If the node contains enough CPU bandwidth, processing rows of data in a session concurrently can increase session performance. However, if you create a large number of partitions or partition points in a session that processes a large amount of data, you can overload the system.

Check the number of CPUs available in a system before running a session with multiple partitions. A simple session that runs in two partitions typically requires twice the amount of CPU than when the session runs in a single partition. If the number of available CPUs is too low to achieve the desired session performance, you may need to adjust the session parameters. Reduce the number of partitions in a session when the number of CPUs is insufficient.