Bored Geek
Computers, Software development, etc. Stuff when I am bored
Friday, September 01, 2006
First thing to do when the execution plan changes
I need to run for every database:
EXEC sp_MSforeachtable "DBCC DBREINDEX ('?')"
EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment