Microsoft KB Archive/274643

= BUG: Estimated Execution Plan Steps Can Show Costs Greater Than 100% =

Article ID: 274643

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q274643



BUG #: 58427 (SQLBUG_70)

BUG #: 236380 (SHILOH)



SYMPTOMS
When you use the Display Estimated Execution Plan option in Query Analyzer, with several queries submitted, the graphical plan may show step optimization costs greater than 100%. The particular query that reproduces this problem is too large and complex to reproduce but it includes a SELECT statement inside of a stored procedure. When that SELECT statement is run outside of the stored procedure, the estimated execution plan looks normal.



CAUSE
This is a graphical user interface (GUI) issue with Query Analyzer.



WORKAROUND
To get the correct numbers, you can calculate them yourself by using the SHOWPLAN option or the statistics profile. For more information about these options, refer to SQL Server Books Online.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB274643

-

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

© Microsoft Corporation. All rights reserved.