Summary information |
|
|---|---|
Default value |
200 |
Range of values |
20 - 2147483647 |
Status |
dynamic |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
Query Tuning |
min pages for parallel scan controls the number of tables and indexes that Adaptive Server can access in parallel. If the number of pages in a table is below the value you set, the table is accessed serially. min pages for parallel scan does not consider page size. If Adaptive Server accesses the indexes and tables, Adaptive Server attempts to repartition the data, if that is appropriate, and to use parallelism above the scans, if that is appropriate.
