Home
  •  

ServiceManager.Report.IncidentManagement.Optimizations.Install (Resource)

Element properties:

TypeResource
File NameServiceManager.Report.IncidentManagement.Optimizations.Install.sql
AccessibilityPublic

Source Code:

<Resource ID="ServiceManager.Report.IncidentManagement.Optimizations.Install" Accessibility="Public" FileName="ServiceManager.Report.IncidentManagement.Optimizations.Install.sql"/>

File Content: ServiceManager.Report.IncidentManagement.Optimizations.Install.sql




/****** Object:  Index [nci1_IncidentDim_ClosedDate]    Script Date: 02/11/2010 11:12:08 ******/


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


DROP INDEX [nci1_IncidentDim_ClosedDate] ON [dbo].[IncidentDim] WITH ( ONLINE = OFF )


GO





/****** Object:  Index [nci1_IncidentDim_ClosedDate]    Script Date: 02/11/2010 11:12:08 ******/


CREATE NONCLUSTERED INDEX [nci1_IncidentDim_ClosedDate] ON [dbo].[IncidentDim] 


(


	[EntityDimKey] ASC,


	[ClosedDate] ASC


)


INCLUDE ( [IncidentDimKey],


[Priority],


[ResolvedDate],


[CreatedDate],


[Id],


[Title],


[TargetResolutionTime],


[Source_IncidentSourceId],


[Status_IncidentStatusId],


[Status],


[TierQueue_IncidentTierQueuesId],


[LastModifiedSource_IncidentSourceId],


[Classification_IncidentClassificationId],


[Impact_IncidentImpactId],


[Urgency_IncidentUrgencyId],


[ResolutionCategory_IncidentResolutionCategoryId],


[IsDeleted])





/****** Object:  Index [nci2_IncidentDim_CreatedDate]    Script Date: 02/11/2010 11:12:08 ******/


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


DROP INDEX [nci2_IncidentDim_CreatedDate] ON [dbo].[IncidentDim] WITH ( ONLINE = OFF )


GO





/****** Object:  Index [nci2_IncidentDim_CreatedDate]    Script Date: 02/11/2010 11:12:08 ******/


CREATE NONCLUSTERED INDEX [nci2_IncidentDim_CreatedDate] ON [dbo].[IncidentDim] 


(


	[EntityDimKey] ASC,


	[CreatedDate] ASC


)


INCLUDE ( [IncidentDimKey],


[Priority],


[ResolvedDate],


[ClosedDate],


[Id],


[Title],


[TargetResolutionTime],


[Source_IncidentSourceId],


[Status_IncidentStatusId],


[Status],


[TierQueue_IncidentTierQueuesId],


[LastModifiedSource_IncidentSourceId],


[Classification_IncidentClassificationId],


[Impact_IncidentImpactId],


[Urgency_IncidentUrgencyId],


[ResolutionCategory_IncidentResolutionCategoryId],


[IsDeleted])





/****** Object:  Index [nci3_IncidentDim_ResolvedDate]    Script Date: 02/11/2010 11:12:08 ******/


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


DROP INDEX [nci3_IncidentDim_ResolvedDate] ON [dbo].[IncidentDim] WITH ( ONLINE = OFF )


GO





/****** Object:  Index [nci3_IncidentDim_ResolvedDate]    Script Date: 02/11/2010 11:12:08 ******/


CREATE NONCLUSTERED INDEX nci3_IncidentDim_ResolvedDate ON [dbo].[IncidentDim] 


(


	[EntityDimKey] ASC,


	[ResolvedDate] ASC


)


INCLUDE ( [IncidentDimKey],


[Priority],


[ClosedDate],


[CreatedDate],


[Id],


[Title],


[TargetResolutionTime],


[Source_IncidentSourceId],


[Status_IncidentStatusId],


[Status],


[TierQueue_IncidentTierQueuesId],


[LastModifiedSource_IncidentSourceId],


[Classification_IncidentClassificationId],


[Impact_IncidentImpactId],


[Urgency_IncidentUrgencyId],


[ResolutionCategory_IncidentResolutionCategoryId],


[IsDeleted])