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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Selects got slower after statistics updated
- Thread starter andreis
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
In order to get back the old statistics you would need to restore the database to it's prior state.
Perhaps you need to flush your procedure cache. If the execution plans are based on the old statistics they may not work correctly if the stats changed that much.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
Perhaps you need to flush your procedure cache. If the execution plans are based on the old statistics they may not work correctly if the stats changed that much.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question