Viewing 5 posts - 16 through 20 (of 20 total)
I just forced the query to serial with OPTION (MAXDOP 1), compared the execution plans -- the numbers are exactly the same in the serial and parallel plans! It would...
November 22, 2011 at 3:18 pm
Thank you for taking time to look at the execution plan! I understand that but where did 22 executions go? They were not qualified!? "... in the Nested Loops Join...
November 22, 2011 at 12:24 pm
Nothing secret, it's just I'm not the owner of the company! They have a policy, I follow 🙂 My boss gave me the green light to post and the plan...
November 22, 2011 at 10:26 am
Sorry, I cannot do it per company's policy. I was hoping you'd know instances when the Nested Loop join behaves this way but anyhow, thank you for your reply.
Denis
November 22, 2011 at 7:05 am
This is a part of the plan where you can see the issue I'm describing. Hope it helps!
Denis
November 21, 2011 at 3:20 pm
Viewing 5 posts - 16 through 20 (of 20 total)