• This happens in concatenation when the path is not executed due to the request being satisfied. The path is not executed (as seen by 0 actual rows after the clustered index scan on clo_AccountAccountDynamicFieldPK_CS) and therefore the actual cost is 0% however the estimated cost is still displayed.

    http://connect.microsoft.com/SQLServer/feedback/details/621330/sum-of-operator-costs-is-more-than-100-in-the-execution-plans

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]