开发者

T-Sql Update Problem

开发者 https://www.devze.com 2023-03-18 03:24 出处:网络
Update Inv01 Set PrintStat = 1 where Inv_No = \'335059\' This query taking too 开发者_如何学Pythonmuch time even nine minutes finished.Please help meIndex your Inv01 table on the Inv_No column, that\

Update Inv01 Set PrintStat = 1 where Inv_No = '335059'

This query taking too 开发者_如何学Pythonmuch time even nine minutes finished.Please help me


Index your Inv01 table on the Inv_No column, that's the only way you're going to speed it up; there's no way to improve the query itself.

0

精彩评论

暂无评论...
验证码 换一张
取 消