CREATE NONCLUSTERED INDEX MwusDevicePatchStatus_EventID_i_DeviceGuid_UpdateGuid_LastChangeTime
    ON [dbo].[MwusDevicePatchStatus] ([EventID])
        INCLUDE ([DeviceGuid],[UpdateGuid],[LastChangeTime])
GO

CREATE NONCLUSTERED INDEX MwusRevision_IsLatestRevisionNumber_i_RevisionID_UpdateGuid
    ON [dbo].[MwusRevision] ([IsLatestRevisionNumber])
        INCLUDE ([RevisionID],[UpdateGuid])
GO

CREATE NONCLUSTERED INDEX MwusDeployment_TargetGroupGuid_LastChangeTime_i_RevisionID_Action_Deadline_DownloadPriority_IsDeleted
    ON [dbo].[MwusDeployment] ([TargetGroupGuid],[LastChangeTime])
        INCLUDE ([RevisionID],[Action],[Deadline],[DownloadPriority],[IsDeleted])
GO
