set current sqlid = 'S100447';
CREATE INDEX OA1T.IWM005AF
ON OA1T.TWM005A1
(TWMD1 ASC,
CGA ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
COMMIT;