if exists(select * from sysindexes where id=object_id('table_1') and name='Index_table_1_id')
  begin 
    drop index table_1.Index_table_1_id;
create index Index_table_1_id on table_1(id)

用在大量更新前删除现有索引..更新完成后重新建立..