May 30, 2008 at 1:15 am
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
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
August 1, 2008 at 12:34 pm
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