Performance tuning

1.txt

-- Dropping PK and creating new PK with CompanyID, ID to align with policy 


ALTER TABLE [dbo].[ContactLists] DROP CONSTRAINT [PK_ContactLists] WITH ( ONLINE = OFF )
GO

ALTER TABLE [dbo].[ContactLists] ADD CONSTRAINT PK_ContactLists PRIMARY KEY CLUSTERED ([CompanyID] ASC, [ID] ASC)
GO

2.txt

-- Preserve fast lookup on ID

CREATE UNIQUE INDEX [IX_ContactLists_ID] ON [dbo].[ContactLists] ([ID])
GO

3.txt

-- Performance tuning - missing index

CREATE NONCLUSTERED INDEX [IX_ContactNotifications_Processed] ON [dbo].[ContactNotifications] ([Processed]) INCLUDE ([ListID])