The optimizer considers the parallel partition scan only for partitioned tables in a query. The table’s data cannot be skewed in relation to the number of partitions, or the optimizer disqualifies partition-based access methods from consideration. Table data is considered skewed when the size of the largest partition is two or more times the average partition size.
Finally, the query must access at least 20 data pages before the optimizer considers any parallel access methods.
