﻿CREATE TABLE [employer_financial].[EnglishFraction]
(
	[Id] BIGINT NOT NULL PRIMARY KEY IDENTITY, 
    [DateCalculated] DATETIME NOT NULL, 
    [Amount] DECIMAL(18, 5) NULL, 
    [EmpRef] NVARCHAR(50) NULL
)

﻿CREATE TABLE [employer_financial].[EnglishFraction]
(
	[Id] BIGINT NOT NULL PRIMARY KEY IDENTITY, 
    [DateCalculated] DATETIME NOT NULL, 
    [Amount] DECIMAL(18, 5) NULL, 
    [EmpRef] NVARCHAR(50) NULL
)

GO

CREATE INDEX [IX_EnglishFraction_Empref_DateCalculated] ON [employer_financial].[EnglishFraction] ([EmpRef], [DateCalculated]) WITH (ONLINE = ON)

Add index for english fraction
Add index for english fraction
