Updating Statistics - Part 2
It's not always enough (or sensible) to rely solely on the auto updating of statistics. Today we'll demonstrate a couple of the methods you can use to update stats on demand.
|
|
|
|
Duration:
|
2
mins
43
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.22
out of 5
|
|
Publish Date:
|
December 04, 2009
|
|
|
|
About the Author
|
|
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
|
|
References
|
There are no downloads or recommended reading links for this video
|
|
|
Comments
|
James Majcen on
12/30/2009
Sss ss ssss sss s stats.
|
|
Steve Harris on
12/30/2009
clear and concise
|
|
R Michael Lacy on
12/30/2009
I believe a rebuild index will also update statistics with a fullscan. I've heard that if you run an update statistics after an index rebuild that it can actually hurt your performance. However if you have non-indexed stats those will not be updated with an index rebuild.
|
|
Lynn Rosini on
12/30/2009
It would have been nice to explain the difference or why you would use one or the other between doing it in a loop and doing it using sp_updatestats.
|
|
|
Brilliant
|
|
|
good
|
|
|
excellent
|
Must Be Logged In
|