开发者

Sql server takes too long time for update query to execute for few rows

开发者 https://www.devze.com 2022-12-18 01:39 出处:网络
开发者_如何学GoUPDATE table1 SET col1=\'True\' This query takes more than 30 secs for about 6000 records. Why is it so slow?Do you have a trigger?
开发者_如何学Go

UPDATE table1 SET col1='True'

This query takes more than 30 secs for about 6000 records. Why is it so slow?


Do you have a trigger?

And see my answers here too: Why does an UPDATE take much longer than a SELECT?

0

精彩评论

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