To utilize the parallel sort to speed up the create index, set the target segment on multiple devices. By using multiple devices, the parallel sort is able to fully use the parellel I/O and Adaptive Server determines the number of consumers for the sort and create index operations based on the number of devices.
You do not necessarily have to slice the table to do the create index with parallel sorting, instead use the create index with the consumer clause. However, if the target segment is not on multiple devices, the Adaptive Server may ignore the number of consumers you specified in the consumer clause.
