sum of cpu cost present in every node in the actual query plan vs, STATISTICS TIME ON, are not same.

Copper Contributor

i run the query with stats on,

SET STATISTICS XML ON;
SET STATISTICS TIME ON;

cpu time i'm getting from STATISTICS TIME and  sum of cpu cost in each node present STATISTICS XML plan have huge difference. this happed for every query that i'm running why this case. usually it should be similar right?
i got very low cpu time in  STATISTICS TIME and high time in sum up all the node cpu time.
0 Replies