Post reply

Additional Index on Subscriber table

  • May 30, 2008 at 2:53 am

    #822156

    Shouldn't be a problem, providing you don't create unique indexes that don't exist in the publisher.

    If the subscription is reinitialised, you'll have to recreate the indexes.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 1, 2008 at 12:34 pm

    #852117

    we do this all the time

    some of our pubs don't replicate indexes and we create a custom set on the sub

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply