请教高手：如何提高UPDATE语句的速度

King2002827

以下语句执行大约需要3-4分钟,有什么方法可以提高其执行速度？
其中sms_no为主键,state为索引

update test
set state = 'O',Oper_time = sysdate
where sms_no in (2015655,2015656,2015657,2015658,2015659,2015660,2015661,2015662,2015663,2015664,2015665,2015666,
2015667,2015668,2015669,2015670,2015672,2015673,2015674,2015675,2015676,2015677,2015678,2015679,2015681,2015682,
2015683,2015684,2015685,2015686,2015687,2015688,2015689,2015690,2015691,2015692,2015693,2015694,
2015695,2015696,2015697,2015698,2015699,2015700,2015701,2015702,2015703,2015704,2015705,2015706)

clytcn

update test
set state = 'O',Oper_time = sysdate
where sms_no >;=2015655 and sms_no <=2015706

孙轩

update test
set state = 'O',Oper_time = sysdate
where (sms_no >;=2015655 and sms_no <=2015670)
or (sms_no >;=2015672 and sms_no <=2015679) or
(sms_no >;=2015681 and sms_no <=2015706);

孙轩

update test
set state = 'O',Oper_time = sysdate
where  sms_no >;=2015655 and sms_no <=2015706
and sms_no not in (2015671,2015680);

King2002827

谢谢各位，现在速度提高了！

unixfansxyc

这两个人说的都可以，那你到底是听谁的？
我没有作测试，但是这两个人的方法到底谁好？

CCBZZP

原帖由 "clytcn" 发表：
update test
set state = 'O',Oper_time = sysdate
where sms_no >;=2015655 and sms_no <=2015706