@SixStringSQL, I think this probably has something to do with your use of the TOP 9999 clause and/or the fact that the WHERE clause includes conditions on columns other than the PK. Can you post an actual execution plan so we can see what happens in detail?