Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a table that has grown quite large that we are replicating to about 120 subscribers. A FK on that table does not have an index and when I ran an Execution Plan on a query that was causing issues it had this to say -->

Missing Index Details from CaseNotesTimeoutQuerys.sql - mylocal\sqlexpress.MATRIX (WWCARES\pschaller (54))
The Query Processor estimates that implementing the following index could improve the query cost by 99.5556%.

CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[tblCaseNotes] ([PersonID])


I would like to add this but I am afraid it will FORCE a reinitialization. Can anyone verify or validate my concerns? Does it even work that way or would I need to run the script on each subscriber?

Any insight would be appreciated.

share|improve this question
You may want to post this on SO. – d-_-b Jun 3 '10 at 0:32
@sims: Done and Thanks. First response SF = 15 hours. Not bad. First response SO = 5 MINUTES, sweet!… – Refracted Paladin Jun 3 '10 at 13:03
up vote 1 down vote accepted

you should be able to add the index to the publisher & subscriber without it forcing a re-initialization

share|improve this answer
Will I need to add it, manually with that script, to each subscriber? It will not propagate down, correct? – Refracted Paladin Jun 3 '10 at 12:34
yes, you need to re-initialize with a snapshot & specify to copy non-clustered indexes, or apply it manually a the subscriber – Nick Kavadias Jun 4 '10 at 4:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.