As Greg had said, we have collapsed tables. Can give you details if needed. Something else we did was to generate a report of how frequently Application Group Segments we being created by CMOD. Creating too many active will cause this problem as well. Throwing multiple Application Groups in one folder speeds up the process too.
Sizing the "Maximum Rows" properly goes a long way. Our general rule of thumb is a Segment per Year's worth of index records. This also depends on how long you are retaining them. That way, proper growth is manageable.
fyi:
003400 SELECT
003500 SUBSTR(NAME,1,10) AS AG_NAME ,
003600 SEG.AGID ,
003800 TABLE_NAME,
003900 DATE(START_DT) AS START_DATE,
004000 DATE(CLOSED_DT) AS CLOSED_DATE,
004100 DAYS(CLOSED_DT) - DAYS(START_DT) AS DAYS_TERM
004200 FROM OND03P.ARSSEG SEG, OND03P.ARSAG AG
004300 WHERE
004400 SEG.AGID = AG.AGID AND
004500 (DAYS(CLOSED_DT) - DAYS(START_DT)) < 200 AND
004600 DATE(CLOSED_DT) > DATE(DAYS(CURRENT DATE) - 90)
004610 ORDER BY AG_NAME, TABLE_NAME;