min pages for parallel scan

Summary information

Default value

200

Range of values

0 - 2147483647

Status

dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

“parallel scan” is the way of running a query in parallel. The ‘min pages for parallel scan’ parameter is a lower limit in order to avoid having small queries produce overhead because of parallel. processing. There is no benefit in having small queries processed in parallel.