Specifies degree of parallelism used in the default index.
Integer
DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
400
The default index calculates some predicates such as SUM, RANGE, MIN, MAX and COUNT DISTINCT in parallel. This option affects the degree of parallelism used by specifying the number of pages worked on by each thread. To increase the degree of parallelism, decrease the value of this option.
