Skip to content

Instantly share code, notes, and snippets.

@danbarua

danbarua/Create_Index.sql

Created November 28, 2014 12:07
Show Gist options
  • Save danbarua/7a5e299c81e37b2f01cb to your computer and use it in GitHub Desktop.
Save danbarua/7a5e299c81e37b2f01cb to your computer and use it in GitHub Desktop.
Download ZIP
Speed up NEventStore 3 projection rebuilds with this index
Raw
Create_Index.sql
/****** Object: Index [IX_Commits_Ordered] Script Date: 11/28/2014 11:59:00 ******/
CREATE NONCLUSTERED INDEX [IX_Commits_Ordered] ON [dbo].[Commits]
(
[CommitSequence] ASC,
[StreamId] ASC,
[StreamRevision] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF) ON [PRIMARY]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment