IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_MISSelect1')
CREATE NONCLUSTERED INDEX IX_MISSelect1
ON [dbo].[MISTABLE] ([DateStamp],[OwnerReservation])
INCLUDE ([ValueType],[HotelCustomerNumber],[ReservationStatus],[ReferenceNumber],[FolioNumber],[WareType])
GO

IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_MISSelect2')
CREATE NONCLUSTERED INDEX IX_MISSelect2
ON [dbo].[MISTABLE] ([DateStamp])
INCLUDE ([ActualAdult],[ActualChildren1],[ActualChildren2],[ActualNumberOfRooms],[ValueType],[HotelCustomerNumber],[ReservationStatus],[ReferenceNumber],[FolioNumber])
GO

IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_MisMonthReport1')
CREATE NONCLUSTERED INDEX IX_MisMonthReport1
ON [dbo].[MISTABLE] ([ValueType],[DateStamp])
INCLUDE ([ReservationStatus],[StaffID],[ReferenceNumber],[FolioNumber])
GO

IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_MisMonthReport2')
CREATE NONCLUSTERED INDEX IX_MisMonthReport2
ON [dbo].[MISTABLE] ([ValueType],[ReferenceNumber])
INCLUDE ([DateStamp],[SegmentNumber],[BookedNumberOfRooms],[ActualNumberOfRooms],[ReservationStatus],[HotelCustomerNumber],[FolioNumber],[WareType])
GO

IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_MisMonthReport3')
CREATE NONCLUSTERED INDEX IX_MisMonthReport3
ON [dbo].[MISTABLE] ([ValueType],[DateStamp],[ReferenceNumber])
INCLUDE ([SegmentNumber],[BookedPrice],[BookedVatOfPrice],[ActualPrice],[ActualVatOfPrice],[ReservationStatus],[HotelCustomerNumber],[StaffID],[ProductWareLinkNumber],[FolioNumber],[IsPackage],[WareType])
GO

IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_MisMonthReport4')
CREATE NONCLUSTERED INDEX IX_MisMonthReport4
ON [dbo].[MISTABLE] ([DateStamp],[ReferenceNumber])
INCLUDE ([SegmentNumber],[BookedAdult],[BookedChildren1],[BookedChildren2],[BookedNumberOfRooms],[BookedPrice],[BookedVatOfPrice],[ActualAdult],[ActualChildren1],[ActualChildren2],[ActualNumberOfRooms],[ActualPrice],[ActualVatOfPrice],[ReservationStatus],[ValueType],[HotelCustomerNumber],[ProductWareLinkNumber],[FolioNumber],[IsPackage],[WareType])
GO
