October 10, 2002 at 4:01 am
What are the benefits of running sp_updatestats on a db?? Does this enhance performance in anyway?? I have seen many discussions posted here that recommend running this sp, especially after migration to newer versions of SQL server. Also is this best to run before or after reorganization of indexes?
October 10, 2002 at 4:29 am
sp_updatestats can improve performance especially as the database gets larger. This is the same thing as having Auot Update Stats turn on for the database. However, Auto Update Stats does not actually run unless a certain amount of data change has taken place, on small databases this is generally not an issue. But large database may not have enough changes to set Auto Update Stats off.
The key performance enhancement is in the way the Query engine in SQL makes index decisions. It is all based on stats, the more unique the higher the likelyhood the index will be used. If stats are not kept up to date then the Query engine may make poor index choices.
The best time to do this is right after an Index reorganization and depending on how often you do that you may want to do the updatestats periodicaly anyway.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 10, 2002 at 5:17 am
Thats great, thanks Antares686.
What about the sp - sp_statistics??? This shows the stats for each table. Do you know how to interpret these, how do I know what is good and what is bad etc???
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply