创建新索引时是否会自动更新统计信息?

Are statistics automatically updated when a new index is created?(创建新索引时是否会自动更新统计信息?)

问题描述

在创建索引后运行 UPDATE Statistics 是否有任何好处，还是自动为您完成?

Is there any benefit to running an UPDATE Statistics after you create an index or is it done automatically for you?

推荐答案

如果新索引需要新的统计信息，它们会自动创建，除非您通过 CREATE INDEX ... WITH 显式禁用新索引的统计信息计算STATISTICS_NORECOMPUTE = ON

If the new index needs new statistics they are automatically created, unless you explictly disable the statistics compute for the new index via CREATE INDEX ... WITH STATISTICS_NORECOMPUTE = ON

这篇关于创建新索引时是否会自动更新统计信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！