Microsoft KB Archive/280458

= BUG: SQL Server May Not Find Existing Appropriate Query Plan Causing Recompilation =

Article ID: 280458

Article Last Modified on 9/4/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q280458



BUG #: 100967 (SQLBUG_70)



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.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Additional query words: plan cache syscacheobjects recompile

Keywords: kbbug kbpending KB280458

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.