Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
@databoffin

This comment has been minimized.

Copy link
Owner Author

@databoffin databoffin commented Jan 15, 2018

Added IX_art_nick_genstatus_subscriber_number_changecount_Included to help sp_msmakegeneration. Could supersede IX_artnick_coldate_genstatus_Included.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.