Forum Discussion
sum of cpu cost present in every node in the actual query plan vs, STATISTICS TIME ON, are not same.
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.
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.
No RepliesBe the first to reply
