quote:

---

In the first query the plan is doing a clustered index seek (as per the index hint). Very optimal. The...

Thanks to all discussion members for their useful and quick answers!

I've been asked about purpose of my stored procedures, so i'd better dicribe the whole situation.

We've got master-server with tape-backup...

Thanks for your answer, Andy.

Actually we've got 6 target servers, but i wanted to tune at least one :). The problem is that jobs_T differs -- there is job_T1 for...