and I always get records with xx = 1, or whatever value I put in the IN clause which is lower than the rest. Note that there is an index (normal, not clustered) declared on XX.

Sorry, comments are closed for this post. If you have any further questions or comments, feel free to send them to me directly.