 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SEC_USER_H_TIME') CREATE INDEX IDX_SEC_USER_H_TIME ON T_SEC_USER_H ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ORG_ORG_H_TIME') CREATE INDEX IDX_ORG_ORG_H_TIME ON T_ORG_ORG_H ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ORG_STRUCTURE_H_TIME') CREATE INDEX IDX_ORG_STRUCTURE_H_TIME ON T_ORG_STRUCTURE_H ( FCREATETIME );