>Did you compare the execution plans for different cases?

Not until you mentioned it. It's very strange the way they are broken up. The one without the order by clause states
that there is a "Nested Loops (Inner Join)" then does an Index Seek and a Key Lookup as well. I don't know what that
means, but I guess I better find out.. lol

Thanks!