ALTER INDEX IX_test_CreatedOn ON dbo.test REORGANIZEIt will block the following:
UPDATE STATISTICS dbo.test IX_test_CreatedOnThen it will block the other statement for a long period of time(during the re-indexing):
select top 1 * from test
Sunday, June 12, 2011
Reindex job and update statistics
When the re-index job(weekly) and update statistics job(daily) are in different schedule, make sure these jobs are running in same time.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment