Execution plan whose components add up to 248%
-
I have attached an execution plan whose components are adding up to 248%
Though I was able to resolve the performance issue I had, I am just curious to know why this happened
Has anybody seen such occurrence before and does any know the reason?
The SQL Server version is 2008 and I get the below result when I select @@VERSION
Microsoft SQL Server 2008 (SP3) - 10.0.5770.0 (X64) Dec 29 2011 17:33:21 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Kingston DhasianHow to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/ -
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.
-
Thanks for the link Sean. That explains it really well.
I was surprised when I saw the plan initially but now I am clear.
Kingston DhasianHow to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply