erb2000 (10/4/2015)
Yes, it is a huge IN clause with hundreds of elements.
Quick suggestion, have a look at this article When is a Seek not a Seek? by Paul White, sounds like this is your problem.
😎
As a fix you could try to change the IN clause to a table.