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 lets you run queries in parallel. The min pages for parallel scan parameter is a lower to avoid having small queries produce overhead during parallel processing. There is no benefit in having small queries processed in parallel.