1

Resolved

What about "Update statistics" / "sp_updatestats"

description

Hi
 
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).
 
Thanks

comments

jaspersmith wrote Apr 17, 2008 at 10:05 PM

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

wrote Apr 17, 2008 at 10:05 PM

jaspersmith wrote Jul 4, 2008 at 10:57 AM

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

wrote Jul 4, 2008 at 10:57 AM

wrote Feb 21, 2013 at 11:09 PM

wrote May 16, 2013 at 11:03 AM

wrote May 16, 2013 at 11:03 AM

wrote Jun 14, 2013 at 7:27 AM