Slick84 (10/14/2009)
Grant,Thank you for the information. Can you possibly point me to the right direction for updating stats on the tables as well as more information for "Full Scans". I will look this up on Google myself as well.
Also, can I update the statistics on these tables in Production during regular business hours? How much effect would updating the statistics have on the database load wise?
Thanks,
S
It could cause issues running it during the day. Normally you can update stats with sp_updatestats, but I think you might need a complete scan done on these based on the wide disparity between the values. To use UPDATE STATISTICS, you just have to run the following for each table:
UPDATE STATISTICS schema.table WITH FULLSCAN
"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