min pages for parallel scan

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.