更新7亿条记录的性能问题 [英] Performance issue for updating 700 million records

问题描述

我在尝试更新包含7亿条记录的表格时遇到性能问题。

I am getting performance issue when trying to update a table which has 700 million records.

我刚刚运行此语句更新 一组B = C FROM TABLE AS A.表上没有索引。

I am just running this statement Update  A set B=C FROM TABLE AS A.There are no indexes on the table.

请您分享最佳实践以改善此性能问题。

Can you please share best practices to improve this performance issue.

推荐答案

小批量更新

PS。如果ID列具有聚集索引

PS. it would good if the ID columns has a clustered index

这篇关于更新7亿条记录的性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！