Working with partitioned indexes
The degree of parallelism for accessing partitioned indexes depends on the nature of the query and on the processor and I/O configuration at your site.
About this task
For an I/O-intensive query, the degree of a parallelism for access to a partitioned index depends on the number of index partitions that are referenced, whereas the degree of parallelism for access to a nonpartitioned index depends on the number of CPs in the system. For a processor-intensive query, the degree of parallelism for both partitioned and nonpartitioned indexes is influenced by the number of CPs in the system.