message threads indexes

indexes.sql

CREATE NONCLUSTERED INDEX [nci_wi_MessageThreads_4AE42CECCF44AA0519F913BAF59A3CFA] ON [dbo].[MessageThreads]
(
	[FromUserDeleted] ASC,
	[FromUserHasArchived] ASC
)
INCLUDE ( 	[CanReply],
	[Created],
	[Subject],
	[ThreadSentTo],
	[ThreadStartedBy],
	[ToUserDeleted],
	[ToUserHasArchived]) WITH (STATISTICS_NORECOMPUTE = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO


ALTER TABLE [dbo].[MessageThreads] ADD  CONSTRAINT [PK_MessageThreads] PRIMARY KEY CLUSTERED 
(
	[MessageThreadId] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
GO