I see. well, I'm running it with read uncommitted isolation level. as i don't care few updates will not be performed exactly as i plan.

as for the execution plan, i see many index seeks and one index scan on a non-clustered index.

how can i know what index is missing? (i ran the missing indexes feature by selecting from the dmv and there is no recommended index to add on that table)

should I look on the predicate? defined values? object? output list?