May I know why they are grouped in Query Columns Tab

kamingbb 2016-06-21 10:09:03

The two Index Seek (highlighted in green and red) are for filtering, they did not group in Query Columns tab. But the two Object3 highlighted in red are grouped together instead.

alt text
alt text

I really want to know the reason why group the two Object3 highlighted in red and leave the Object3 highlighted in green in another group. I'm sorry asking such a stupid question, because I am a newbie in SQL tuning.

I just want to learn what's the purpose such grouping served to help me understand the problem in my SQL!


Aaron Bertrand 2016-06-30 17:29:54
Are you simply asking why there isn't a thicker line between those two operations in the query columns tab?
kamingbb 2016-07-04 06:43:46
Thank you Aaron. Yes, they seems unrelated.
Aaron Bertrand 2016-07-06 16:36:09
This is a minor defect in the grid control in that it occasionally won't render a more solid line between column groups. It will be resolved in a future build of Plan Explorer. Sorry for the inconvenience.