April 15, 2009 at 2:11 am
Hello,
According from the forums on Internet, most of the people said that 'Need to Update Statistics' on the Databases to make the query faster and indexing better. Is that correct? I have 4 production server which we had never run 'EXEC sp_UpdateStats' except Auto_Update_Statistics and Auto_Create_Statics ON in Database Properties.
Do I have to run above command to all my production server? Why I need to run this, please explain me becasue I am not quite understand about the STATISTICS.
Thank.
Leo
April 15, 2009 at 2:21 am
SQL does update statistics automatically. It's when that it switched off, or doesn't happen often enough that you have to manually update the stats.
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
April 15, 2009 at 2:23 am
And when you migrate from one version of SQL to another.
"Keep Trying"
April 15, 2009 at 2:29 am
Plus index rebuilds update statistics, so if you have regular complete index rebuilds that may take care of the stats.
Honestly, on systems that I've maintained, I've only seen two tables (out of 400 in a 1.2 TB database) that needed manual stats updates. The rest the automatic updates handled just fine.
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
April 15, 2009 at 6:38 am
Thank you everyone.
Leo
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply