BUG: Estimated Execution Plan Steps Can Show Costs Greater Than 100% (274643)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
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.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB274643
©2003 Microsoft Corporation. All rights reserved.