July 20, 2010 at 10:28 am
Hi,
Iam little bit confused about the topic statistics ,how to identify the statistics that are out of date.
we use DBCC SHOW_STATISTICS to find the when the statistics last updated.
can any please clarify me
Koteswar rao
July 20, 2010 at 11:03 am
You can use the STATS_DATE function to determine the last time the statistics were updated.
You should also check out sp_updatestats. The benefit of it, starting with 2005, is that it determines which statistics need updating. If any stats are up to date, then it won't update them. For this reason, we don't even bother checking if stats are out of date. We just run sp_updatestats.
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
Ramblings of a DBA (My SQL Server Blog)[/url]
Subscribe to my blog
July 20, 2010 at 11:18 am
There's a new post coming up on my blog on Friday that's an introduction to statistics as part of SQL University's Index Week. Keep an eye out for it. It might help explain a few things. Gail has a great post on them available now[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply