Article ID: 933697 - View products that this article applies to.
When you run a SELECT query in Microsoft SQL Server 2005 Mobile Edition and in Microsoft SQL Server 2005 Compact Edition, the query unexpectedly returns an incorrect number of rows. This problem occurs if the following conditions are true:
Note In this example, table T1 has an index on column Col. Table T2 does not have an index on column Col1.
This problem occurs because the query optimizer does not discard the previous plan completely. The query optimizer considers multiple query plans before the query optimizer decides on the best plan to execute a query. In some cases, the query optimizer can find a plan that uses an index to evaluate the condition. However, the query optimizer may later find a better plan. In this case, the query optimizer discards the previous plan to use the better plan.
To resolve this problem, use one of the following methods:
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
Steps to reproduce the problem