The with consumers clause for update statistics is designed for use on partitioned tables on Redundant Array of Independent Disks (RAID) devices, which appear to Adaptive Server as a single I/O device, but can produce the high throughput required for parallel sorting. See Chapter 9, “Parallel Sorting” in Performance and Tuning: Optimizer and Abstract Plans for more information.
