Additional Index on Subscriber table

• Paresh Randeria

  Ten Centuries

  Points: 1150

  More actions

  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.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  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