HADR:
If I need to rebuild indexes, can I do this on the primary?
Index operations are fully logged and will be replicated to the secondaries.
Replication:
CREATE INDEX and ALTER INDEX are not replicated, so if you add or change an index at, for example, the Publisher, you must make the same addition or change at the Subscriber if you want it reflected there.
we need to rebuild stats also
If I need to rebuild indexes, can I do this on the primary?
Index operations are fully logged and will be replicated to the secondaries.
Replication:
CREATE INDEX and ALTER INDEX are not replicated, so if you add or change an index at, for example, the Publisher, you must make the same addition or change at the Subscriber if you want it reflected there.
we need to rebuild stats also
No comments:
Post a Comment