您多久更新一次 SQL Server 2000 中的统计信息?

问题描述

我想知道之前更新统计数据是否对您有帮助，您是如何知道更新它们的?

I'm wondering if updating statistics has helped you before and how did you know to update them?

推荐答案

exec sp_updatestats

是的，如果您发现查询没有达到应有的效果，更新统计信息会非常有用.这可以通过检查查询计划并注意何时执行表扫描或索引扫描而不是索引查找来证明.所有这些都假设您已正确设置索引.

Yes, updating statistics can be very helpful if you find that your queries are not performing as well as they should. This is evidenced by inspecting the query plan and noticing when, for example, table scans or index scans are being performed instead of index seeks. All of this assumes that you have set up your indexes correctly.

还有 UPDATE STATISTICS 命令，但我'我个人从未使用过.

There is also the UPDATE STATISTICS command, but I've personally never used that.