max pages for parallel scan controls the tables and indexes that can be accessed in parallel. If the number of pages in a table is below this value, the table is accessed serially. The default value is 200 pages; page size is not relevant. Although the tables and indexes of the table are accessed serially, Adaptive Server tries to repartition the data, if that is appropriate, and to use parallelism above the scans, if that is appropriate.
