ian - i don't see how what you describe can happen unless the query is more complex than the one shown. I assume you are not suggesting that the query plan adopted affects the records returned. However, if this is a problem, it's potentially a major one. Do you have the code of the two statements, by any chance? Failing that, can you give any more info on the circumstances in which this happens?