BUG: SQL Server May Not Find Existing Appropriate Query Plan Causing Recompilation (280458)

SYMPTOMS

When a SQL statement is executed in SQL Server 7.0, SQL Server first looks through the procedure cache to see if there is an existing query plan for the same SQL statement. SQL Server 7.0 reuses any existing plan that it finds, saving the overhead of recompiling the SQL statement.

Under rare circumstances, SQL Server may not find the existing appropriate query plan and a recompilation may be incurred. You might notice that a query takes much longer to run due to the recompilation.