The examples in this section show how the limits to the degree of parallelism affect the following types of queries:
A partition heap table
A nonpartitioned heap table
A table with a clustered index