June 27, 2009 at 8:16 am
I know in SQL Server 2005 / 2008 the sp_updatestats is optimized to perform work only on the statistics that need to be updated, but this doesn't seem to be the case in 2000. I was doing some research online regarding how to figure out which stats need updating and I'm not entirely clear on one thing in particular... If you have a STATS_DATE of NULL, does that always mean you should skip running update stats on an object?
For instance, if I have a heap table (index ID 0) and there are no specific statistics created on that table, do I ever want to run update stats on it?
Do I want to go solely by the number of records in the table and the rowmodctr in sysindexes or do I want to go by that AND the STATS_DATE() value?
Any guidance is appreciated, thanks
John
June 27, 2009 at 9:42 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic743117-5-1.aspx
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
June 27, 2009 at 11:15 am
I tried to delete this thread because it's in the 2005 forum, the question should really be in the 2000 forum but it doesn't seem to be deleting it properly.
June 27, 2009 at 11:20 am
Threads once posted can't be deleted. If you post in the wrong forum, either note it in the post and request the mod to move it (via Report), or post a thread in the right forum and edit the old one to have a link to the correct one.
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply