----------------------- MwusDevicePatchStatus_03   INDEX [MwusDevicePatchStatus_EventID_LastChangeTime]
if ( 0 = dbo.udf_Conv_DoesIndexExist  ('MwusDevicePatchStatus','MwusDevicePatchStatus_EventID_LastChangeTime' ))
begin
        -- NC Indexes after data migration
         PRINT ' MwusDevicePatchStatus_03 CREATE NONCLUSTERED INDEX [MwusDevicePatchStatus_EventID_LastChangeTime]'
        --------------------         
        CREATE NONCLUSTERED INDEX [MwusDevicePatchStatus_EventID_LastChangeTime] ON [dbo].[MwusDevicePatchStatus]
        (
	        [EventID] ,LastChangeTime desc
        )

end -- 7470_102-MR2_MwusDevicePatchStatus_RowID.sql