Code can't be altered, what's the right index on table OCRSetQueue to turn into an index seek?

OSU03LM 2015-06-19 20:44:10

This is an independent software vendor, so a code change is impractical.

SQLkiwi 2015-06-19 23:49:25
Probably:

CREATE INDEX i
ON eddsdbo.OCRSetQueue
    (Status, Priority, SubmittedDate)
INCLUDE
    (SetQueueID, AgentName)
WHERE
    AgentName <> 'ERROR';