Nonpartitioned heap table

If the query involves a join, and max scan parallel degree is set to 3, and the nonpartitioned heap table is the outer table in the query, then the optimizer considers the following access methods:

If max scan parallel degree is set to 1, then the optimizer does not consider the hash-based scan.

See “Single-table scans” for more examples of determining the degree of parallelism for queries.