May 2, 2008 at 6:19 am
Hi,
We need to create a maintenance paln to make sure that all tables/indexes/views are calculated with new statistics updates
Is there any other method to do the same
Regards,
Smm
May 2, 2008 at 7:03 am
Just out of curiosity, do you have auto-stats turned on? Is it not doing a good enough job for you?
You can see the following from BOL to get more information on updating statistics.
http://msdn.microsoft.com/en-us/library/ms187348.aspx
You could use the example to update all the stats for a particular table and wrap that inside of the undocumented sp_MSforeachTable stored procedure to recompute stats for all of your tables...
-Luke.
July 14, 2015 at 7:10 am
Luke L (5/2/2008)
Just out of curiosity, do you have auto-stats turned on? Is it not doing a good enough job for you?You can see the following from BOL to get more information on updating statistics.
http://msdn.microsoft.com/en-us/library/ms187348.aspx
You could use the example to update all the stats for a particular table and wrap that inside of the undocumented sp_MSforeachTable stored procedure to recompute stats for all of your tables...
-Luke.
Hi Luke,
Can you please let me know how to check the details of update statistics which ran on database after a particular date.
Ex: How to find on which tables update stats ran after jun27th on a particular database ?
July 14, 2015 at 7:13 am
Please post new questions in a new thread. Thank you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply