用rebuile语句即可啊
Alter indexindex_name rebuild;Alter indexindex_name rebuild online;
也可以把索引删除了重新建立
drop index indexindex_name;create index indexindex_name on table_name(col_name);
