views:

33

answers:

3

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
A: 

Here's a good article to help you out

JonH
+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
thanks for the fix Neil
Remus Rusanu