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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


24
0
Sign in
to vote
ID 370798 Comments
Status Closed Workarounds
Type Bug Repros 4
Opened 9/29/2008 12:08:04 PM
Duplicates 436184 Access Restriction Public

Description

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.

Thanks,
-Karthik