---删除旧索引
DROP INDEX IDX_ORDERLOG_SEARCH1;
--重新建新索引
CREATE INDEX "IDX_ORDERLOG_SEARCH1"
    ON "DB_ORDERLOG"  ("ORDERID")
    TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 2 MAXTRANS 255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
    LOGGING;