December 2, 2022 at 7:18 am
In Transactional Replication, create index and Alter index commands do not get replicated to subscriber. Does UPDATE STATISTICS command get replicated to subscriber?
December 3, 2022 at 8:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 3, 2022 at 10:18 am
This was removed by the editor as SPAM
December 3, 2022 at 10:44 pm
No update statistics do not get replicated either.
The only caveat to that would be when enough of the data has changed to kick off an AUTO UPDATE statistics background thread.
replication is only concerned about insert/update/delete and any execute statements (if you replicate procedure calls) that change the actual data.
it doesn’t replicate anything at the index or statistic level.
December 4, 2022 at 1:56 pm
So, UPDATE STATISTICS command gets replicated in ALwaysOn, Mirroring and Log shipping?
December 4, 2022 at 2:51 pm
Yes in those technologies all commands are synchronised as they take a full copy of the transaction log.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply