Excellent suggestion! That should resolve the issue rather nicely.

Thanks

After closer inspection I think the underlying issue is that the 'select from' table is a heap with several non-clustered indexes on frequently queried columns. What baffles me is that...