Adding FK Index to existing table in Merge Replication Topology
Posted
by Refracted Paladin
on Server Fault
See other posts from Server Fault
or by Refracted Paladin
Published on 2010-06-02T15:09:20Z
Indexed on
2010/06/02
15:14 UTC
Read the original article
Hit count: 365
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%.
*/
/*
USE [MATRIX]
GO
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[tblCaseNotes] ([PersonID])
GO
*/
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.
© Server Fault or respective owner