In most cases, configuring the physical layout of tables and indexes on devices is the key to parallel performance. Spreading partitions across different disks and controllers can improve performance during partition-based scanning if all of the following conditions are true:
Data is distributed over different disks.
Those disks are distributed over different controllers.
There are enough worker processes available at runtime to allocate one worker process for each partition.