Yes, that was the conclusion we came to. I was just curious if there was any other way of resolving this.

Thanks.

That option is not selected so it can't be that.

Thanks for confirming.

Thanks for your reply Scott.

Yes, you're right of course, I will look at optimising the indexes based on the usage and other stats gleaned from the DMVs. I was just...

Thanks for that Grant.

Looking at the Execution Plan for the query I can see that in fact there are two separate operations, the Key Lookup and then a Clustered Index...

Thanks

Thanks very much for that. That confirms what we suspected.