Parallel queries that require worktables create partitioned worktables and populate them in parallel. For queries that require sorts, the parallel sort manager determines whether to use a serial or parallel sort.
See Chapter 9, “Parallel Sorting,” for more information about parallel sorting.