Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2007-03-30 : 10:17:34
|
| I have a weekly maintenance program that deletes around 100,000 records from various application tables.Question is :Do I need to run an sp_updatestats after this job?I already have updatestats selected in DB options.thanks |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-03-30 : 12:50:30
|
| Its a good idea to run an update stats on the tables after the deletes. Although you have Auto update stats selected, its up to SQL Server to decide when to actually update the stats. If it thinks the sampling ratio has changed enough that it has to go and update.************************Life is short. Enjoy it.************************ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-03-30 : 12:51:35
|
| You mean auto update stats?Why are you deleting the data?But I have another question...in DB2 when I update stats I have to rebind all of the sproc before they can use the new stats...Is the ssame true in SQL Server? I didn't think so, but it must be the same...do I have to clear the cache?And if you have auto update, then I'd say...but I would say the auto might impact performanceBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
|
|
UpdateStats