Indexes for merge replication.sql

CREATE NONCLUSTERED INDEX [IX_pubid_uploadoptions]
ON [dbo].[sysmergearticles]
(
    [pubid],
    [upload_options]
);
GO
CREATE NONCLUSTERED INDEX [IX_uploadoptions_Included]
ON [dbo].[sysmergearticles] ([upload_options])
INCLUDE
(
    [artid],
    [pubid],
    [nickname]
);
GO
CREATE NONCLUSTERED INDEX [IX_rowguid_origindatasource]
ON [dbo].[MSmerge_conflicts_info]
(
    [rowguid],
    [origin_datasource]
);
GO
CREATE NONCLUSTERED INDEX [IX_pubid_artid]
ON [dbo].[sysmergeschemachange]
(
    [pubid],
    [artid]
);
GO
CREATE NONCLUSTERED INDEX [IX_art_nick_genstatus_subscriber_number_changecount] ON [dbo].[MSmerge_genhistory]
(
	[art_nick] ASC,
	[genstatus] ASC,
	[subscriber_number] ASC,
	[changecount] ASC
);
GO
CREATE NONCLUSTERED INDEX [IX_artnick_coldate_genstatus] ON [dbo].[MSmerge_genhistory]
(
	[art_nick] ASC,
	[coldate] ASC,
	[genstatus] ASC
);
GO

Added IX_art_nick_genstatus_subscriber_number_changecount_Included to help sp_msmakegeneration. Could supersede IX_artnick_coldate_genstatus_Included.