SQL Server Performance

Will index on a table get replicated?

Discussion in 'Performance Tuning for SQL Server Replication' started by antonymd, Jul 16, 2003.

  1. antonymd New Member


    Let me straight a way put my question.
    I have a table which is set for replication.
    I want to add an index to this table which is get replicated.
    I would like to know whether this index will get replicated.

    Also I would like to know whether there are any methods to prevent indexes from being replicated.

    The purpose is that: I want to keep index on one table but dont want the index to be replicated(if index is also replicated).

    Please help me with your valuable advices.
    Thanks in advance

    Aji Menachery.
  2. bradmcgehee New Member

    You can manage indexes separately on the publisher and the subscriber databases, once the initial replication has occured.

    Brad M. McGehee, MVP
  3. antonymd New Member

    Thank you very much Brad for the reply!

    In between we tried including an index in 2 tables which are marked for replication.
    We are running merge replication.
    Also the subscriber has a Pull Subscription scheduled.
    And we found that indexes are not replicated.

    I must say this!!
    www.sql-server-performance.com is ofcourse a wonderful place with immense resources and tips!
    I would defenetly recommend this to my colleagues and friends.

    Once again, thanking you for the reply.

    Aji Menachery

Share This Page