Katmai: [also 2005] Graphical plan operator costs exceed 100% - by Steve Kass

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.

Sign in
to vote
ID 285970 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 7/3/2007 11:36:41 AM
Access Restriction Public


Sometimes the query operator costs shown in a graphical query plan exceed 100%.
Sign in to post a comment.
Posted by Microsoft on 12/2/2007 at 8:43 PM
Hi Steve,
     The cost of the conditional statement itself is logically the cost of of executing the conditional -- it should be independent of whether the then\else branches are taken. Changing the cost to some combination of 'conditional', 'else', 'then' cost is just hacking around the problem. It's non-trivial to determine the 'else' and 'then' costs since they can be arbitrary sets of statements.

     Anyone looking directly at the showplan xml isn't going to be confused (clearly labeled <cond>, <then>, <else> segements + their costs) -- Its the percentages in the graphical representation which are confusing. Ideally this graphical representaion would have some other graphic for conditionals\loops and not treat them like an operator tree (i.e., becuase a conditional statement has three children, doesn't mean all three children will be executed). This would make the graphical representaion easier to read (right now you can't tell which child is the then\else\conditional part) and would also make the odd precentages shown disappear.
     Give what we have left to do in the release, we will not be fixing this issue.
Thank you,
Bill Ramos
Posted by Microsoft on 9/6/2007 at 9:03 AM
Hello -

We'll check out the repro steps and assign this to a developer. Thanks for the catch!

Buck Woody, SQL Server Program Manager
Posted by AaronBertrand on 7/3/2007 at 11:44 AM
I filed a very similar problem in connect ID # 267530