----------------------- 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 -- 510_102-MR3-HF2_MwusDevicePatchStatus_30-Index_ExpressOnly.sql