USE [ION_Data]
GO
/****** Object:  StoredProcedure [dbo].[RebuildAlarmRelatedIndexes]    Script Date: 1/15/2020 10:02:02 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[RebuildAlarmRelatedIndexes] AS
BEGIN
 ALTER INDEX ALL ON dbo.[Alarm] REORGANIZE;
ALTER INDEX ALL ON dbo.[AlarmAcknowledgement] REORGANIZE;
ALTER INDEX ALL ON dbo.[AlarmDefinition] REORGANIZE;
ALTER INDEX ALL ON dbo.[AlarmEvent] REORGANIZE;
ALTER INDEX ALL ON dbo.[AlarmStates] REORGANIZE;
ALTER INDEX ALL ON dbo.[Incident] REORGANIZE;
ALTER INDEX ALL ON dbo.[IncidentAlarm] REORGANIZE;
ALTER INDEX ALL ON dbo.[EventString] REORGANIZE;
ALTER INDEX ALL ON dbo.[EventLog2] REORGANIZE;
ALTER INDEX ALL ON dbo.[PQ_Events] REORGANIZE;
ALTER INDEX ALL ON dbo.[WaveformLog2] REORGANIZE;
END
