Home Dashboard Directory Help

Query plan: iterator cost percentage way off... by Adam Machanic


 as Won't Fix Help for as Won't Fix

Sign in
to vote
Type: Bug
ID: 370798
Opened: 9/29/2008 12:08:04 PM
Access Restriction: Public
Duplicates: 436184
User(s) can reproduce this bug


Table spools can be costly, but 1053066% of the plan cost? I think that's a bit extreme! See attached .SQLPLAN file and screen shot.
Sign in to post a comment.
Posted by Microsoft on 2/1/2012 at 2:12 PM
Hello Adam,

I am resolving this feedback item as a duplicate of another item that will aggregate all the DCRs related to Showplan so that they can be considered and prioritized as a group. This action represents neither a promise to act on the item nor a decision to reject the request. At this point I cannot promise a timeline regarding when any decisions will be made or actions taken.

Thank you for providing feedback and helping us to improve SQL Server.

Susan Price
Program Manager
SQL Server Database
Posted by Microsoft on 2/13/2009 at 10:52 AM
Hi Adam Machanic,

Thank you for reporting the problem. As you rightly point out the percentage calculation seems to be in error. Neither the plan nor the execution is affected by this calculation.

I have marked this bug to the product team for fixing it in a future release.

Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
huge_pct.bmp (restricted) 9/29/2008 -
ExecutionPlan2.sqlplan (restricted) 9/29/2008 -