Home Forums SQL Server 7,2000 Administration How to TEST if statistics should be updated. RE: How to TEST if statistics should be updated.
hampsont
SSC Enthusiast
Points: 100
More actions
December 30, 2003 at 8:17 am
#488191
How is the reindexing being done?
dbcc reindex updates statistics but if you are using indexdefrag I believe the statistics are not updated. Might be worth looking into if you did not write the weekly process.
Trevor HampsonDBA