SQL Kiwi (1/12/2012)
There is no 'bookmark lookup' in this case as Jeff's explanation of point H reveals: the non-clustered index is covering for the query.
Sounds right.
I need to find out what did I do wrong to make it do scan instead of seek in my test case.
🙂
_____________
Code for TallyGenerator