SET CURRENT SQLID='S100447';
DROP INDEX GDB9998.IWK001A2;
COMMIT;
CREATE INDEX GDB9998.IWK001A2
ON DGDB9998.TWK001A
(WK001NAME ASC,
WK001NUM ASC,
WK001ID ASC,
WK001T1 ASC)
USING STOGROUP GSMS
PRIQTY 12 SECQTY 12
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
COMMIT;