创建新索引时是否自动更新统计信息？
问题描述：
创建索引后运行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