This parameter controls which tables and indices may 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 indices 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.
