SQL Server automatically update statistics according to few rules.
In order to force statistics update (even when SQL Server rules are not met) - use WITH FULLSCAN.
UPDATE STATISTICS TABLENAME WITH FULLSCAN
Note: sp_autostats doesn't force the statistics update.
No comments:
Post a Comment