What about "Update statistics" / "sp_updatestats"


Could you consider adding "updatestats" as an extra maintenance operation?
I can see that I can use "REINDEX" to rebuild indexes, and that will take care of the statistics as well, but since using WITH (ONLINE = ON) is not available in "SQL Express", it means that each table will become inaccessible during the rebuild.
But if I use "REORG", there is no option to update statistics after that, and in many cases thats the best way to optimize query performance.
On small databases, running "UPDATE STATISTICS tablename WITH FULLSCAN" on all tables, will not take too long (and will not lock the tables during the operation).


jaspersmith wrote Apr 17, 2008 at 10:05 PM

Good suggestion, I'll add it to the next release

jaspersmith wrote Jul 4, 2008 at 10:57 AM

This functionality has been added to version with the new STATS and STATSFULL operations