USE [EnVisage]
GO

CREATE NONCLUSTERED INDEX [NCLX_IDX_ScenarioDetail_ParentId_ExpCid_WeekendDate_2]
ON [dbo].[ScenarioDetail] ([WeekEndingDate],[ParentID],[ExpenditureCategoryId])
INCLUDE ([Id],[Quantity],[LastUpdate],[WeekOrdinal],[Cost])
 
CREATE NONCLUSTERED INDEX [NCLX_IDX_ScenarioDetail_ParentId_ExpCid_WeekendDate]
ON [dbo].[ScenarioDetail] ([ParentID],[ExpenditureCategoryId],[WeekEndingDate])
INCLUDE ([Id],[Quantity],[LastUpdate],[WeekOrdinal],[Cost])
 
CREATE NONCLUSTERED INDEX [NCLX_IDX_ScenarioDetail.ParentID]
ON [dbo].[ScenarioDetail] ([ParentID])
INCLUDE ([ExpenditureCategoryId],[WeekEndingDate],[Cost])
GO