alter table tablename disable trigger all
drop index tablename.indexname
--之后进行更新
update tablename set coln = new
alter table tablename enable trigger all
create index indexname on table(col4)
drop index tablename.indexname
--之后进行更新
update tablename set coln = new
alter table tablename enable trigger all
create index indexname on table(col4)