Gail

The first ORDER BY in the original post matches the clustered index, albeit with the unnecessary addition of a second column.

I think you're right - a sort would be necessary. Maybe the sort would have to do less work if the data is already ordered. I don't know - I haven't tried it. This is why I said to Bhuvnhesh that he must test thoroughly.

John