min pages for parallel scan controls the number of tables and indexes that SAP ASE can access in parallel.
|
Summary Information |
|
|---|---|
|
Default value |
200 |
|
Range of values |
20 - 2147483647 |
|
Status |
dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Query Tuning |
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 SAP ASE accesses the indexes and tables, SAP ASE attempts to repartition the data, if that is appropriate, and to use parallelism above the scans, if that is appropriate.