Transactional Replication Index and Statistics commands

Question

Hi,
Transactional Replication replicates on transaction-by-transaction basis. Then, why CREATE INDEX statement and ALTER INDEX statements don't get replicated. Also, why UPDATE STATISTICS command gets replicated when index statements are not replicated

Answer 1

Hi @Chaitanya Kiran ，

Please check out this doc, it said adding, dropping, or altering indexes is not supported, it is not within the range of schema changes, this doc lists all DDL statements, for transactional replication, if the subscriber republishes data, the only supported schema changes are adding and dropping a column
Make Schema Changes on Publication Databases

An index is a schema object, but statistics is not, it is similar to other transaction log records

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I don't do much replication, but I believe whether to replicate index creation is an option on the publication.

I guess the reason that index creation is not replicated by default is that you often want different indexes on the publisher (which may be an OLTP database) and the subscriber(s) (which may be used for reporting).