Using the with consumers clause

The with consumers clause for update statistics is designed for use on partitioned tables on RAID devices, which appear to Adaptive Server as a single I/O device, but which are capable of producing the high throughput required for parallel sorting. See chapter 9, Parallel Sorting in the Performance and Tuning: Optimizer and Abstract Plans for more information.