Home
  •  

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

Element properties:

TypeResource
File NameServiceManager.Report.ActivityManagement.SP.ReportOptimizations.Install.sql
AccessibilityPublic

Source Code:

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

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

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


DROP INDEX [NCI_ActivityDim_ADK_EDK] ON [dbo].[ActivityDim]


GO





CREATE NONCLUSTERED INDEX [NCI_ActivityDim_ADK_EDK] ON [dbo].[ActivityDim] 


(


	[ActivityDimKey] ASC,


	[EntityDimKey] ASC,


	[CreatedDate] ASC,


	[Id] ASC


)


INCLUDE ( [Status_ActivityStatusId],


[Stage_ActivityStageId]) 


GO