The following sections describe the resources used by Adaptive Server when sorting data in parallel:
Worker processes read the data and perform the sort.
Sort buffers pass data in cache from producers to consumers, reducing physical I/O.
Large I/O pools in the cache used for the sort also help reduce physical I/O.
Reference to Large I/Os are on a 2K logical
page size server. If you have an 8K page size server, the basic
unit for the I/O is 8K. If you have a 16K page size server,
the basic unit for the I/O is 16K.
Multiple physical devices increase I/O parallelism and help determine the number of worker processes for most sorts.
