Hard to say without knowing data patterns. Alt indexes can speed things up a lot another is interchange sort order and take Sortout of Long sort(1-24) and feed into the short sort 1-3,17-24.
In a message dated 08/30/13 17:22:10 Central Daylight Time, [email protected] writes: You're right, the sort orders are not the same. For the CPU example I gave below, the first sort uses these parameters: ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
