Post reply

Additional Index on Subscriber table

  • May 30, 2008 at 1:15 am

    #188288

    I am using Subscription database for Reporting. I have performance issue creating too many indexes on Publisher database table.

    Can I create additional index on Subscriber Table which do not exists in Publisher Table?

    I didn't see this topice discussed. If this topic is discussed than point me to that topic.

    Thanks in advance for your response.

  • 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 3 posts - 1 through 2 (of 2 total)

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