How do I add or change indexes on publication and subscription databases?
Indexes can be added at the Publisher or Subscribers with no special considerations for replication (be aware that indexes can affect performance). 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.
Related Questions
- I don have a subscription to one or more of the subscription database websites (Ancestry, Footnote, WorldVitalRecords, etc.). How else can I access these databases?
- How can I see what online indexes or databases are available through Marshall University Libraries?
- How do I add or change indexes on publication and subscription databases?
