创建新索引时是否会自动更新统计信息?
在创建索引后运行 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
相关文章