Parallel sorting employs multiple worker processes to sort data in parallel, similar to the way multiple worker processes execute a query in parallel. create index and any query that requires sorting can benefit from the use of parallel sorting.
The optimizer does not directly optimize or control the execution of a parallel sort.
See “Parallel query examples” for examples of queries that can benefit from the parallel sorting strategy.
Also, see “Overview of the parallel sorting strategy” for a detailed explanation of how Adaptive Server executes a sort in parallel.