Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating Statistics

Status
Not open for further replies.

MasterRacker

New member
Oct 13, 1999
3,343
US
If you have DB that's set to auto-update statistics, when would you need to update statistics manually or in a maintenance plan?

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]
 
Jeff,

I update stats weekly, during a time period of low usage. It may be overkill but I just want to make certain SQL Server is aware of the best access paths.

John
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top