on your case I would be interested in seeing how it behaves if you do a insert into a temp table instead of plain retrieval.

And can you also add (and...

Hello Jeff, thank you for you explanation, i absolutely agree with you, but situation i have is that on separate disk for log files i have physically limited space which...