Is there any benefit to running an UPDATE Statistics after you create an index or is it done automatically for you?
A:
Om 2005, at least, they are created automatically with CREATE INDEX
:
http://technet.microsoft.com/en-us/library/cc966419.aspx#XSLTsection129121120120
davek
2009-12-18 21:26:31
+1
A:
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
Remus Rusanu
2009-12-18 21:29:43
thanks for the fix Neil
Remus Rusanu
2009-12-18 22:33:25