ServiceManager.Report.ReleaseManagement.SP.ReportOptimizations.Install (Resource)

Element properties:

Source Code:

<Resource ID="ServiceManager.Report.ReleaseManagement.SP.ReportOptimizations.Install" Accessibility="Public" FileName="ServiceManager.Report.ReleaseManagement.SP.ReportOptimizations.Install.sql"/>

File Content: ServiceManager.Report.ReleaseManagement.SP.ReportOptimizations.Install.sql

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ReleaseRecordDim]') AND name = N'NCI_ReleaseRecordDim_CDateEntityDimKey')


DROP INDEX [NCI_ReleaseRecordDim_CDateEntityDimKey] ON [dbo].[ReleaseRecordDim] 


GO





CREATE NONCLUSTERED INDEX [NCI_ReleaseRecordDim_CDateEntityDimKey] ON [dbo].[ReleaseRecordDim] 


(


	[EntityDimKey] ASC,


	[CreatedDate] ASC


)


INCLUDE ( [ReleaseRecordDimKey],


[Status_ReleaseStatusId],


[Category_ReleaseCategoryId],


[Category],


[Priority_ReleasePriorityId],


[Impact_ReleaseImpactId],


[Risk_ReleaseRiskId],


[ImplementationResults_ReleaseImplementationResultsId],


[Id],


[ScheduledStartDate],


[ScheduledEndDate],


[ActualStartDate],


[ActualEndDate]) 


GO








IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ReleaseRecordDim]') AND name = N'NCI2_ReleaseRecordDim_CreatedDate')


DROP INDEX [NCI2_ReleaseRecordDim_CreatedDate] ON [dbo].[ReleaseRecordDim] 


GO





CREATE NONCLUSTERED INDEX [NCI2_ReleaseRecordDim_CreatedDate]





ON [dbo].[ReleaseRecordDim] ([CreatedDate])





INCLUDE ([ReleaseRecordDimKey],


[EntityDimKey],


[Status_ReleaseStatusId],


[Category_ReleaseCategoryId],


[Category],


[Priority_ReleasePriorityId],


[Impact_ReleaseImpactId],


[Risk_ReleaseRiskId],


[ImplementationResults_ReleaseImplementationResultsId],


[Id],


[Title],


[ScheduledStartDate],


[ScheduledEndDate],


[ActualStartDate],


[ActualEndDate])





GO