Turning on execution plans affects performance
When performance tuning I often use a combination of
Execution Plans, SET STATISTICS IO and SET STATISTICS TIME. what I've noticed
lately is that when using TIME and actual execution plans the teim and cpu
reports is very large. If I turn off actual execution plans the duration
drastically reduces. I can understand this as the execution plan has to be put
together and sent to the client, but it is very noticeable.
Whats more is that the extra duration seesm to be different for different
query plans.
So word of warning if you are doing some performance tuning and are trying to
compare CPUT and duration , you don't want to have execution plans turned on as
this will skew the result.