Is there any benefit to running an UPDATE Statistics after you create an index or is it done automatically for you?
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
Om 2005, at least, they are created automatically with CREATE INDEX
:
http://technet.microsoft.com/en-us/library/cc966419.aspx#XSLTsection129121120120
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With