Meaning of Group By Checkbox in Query Columns

kamingbb 2016-06-17 03:54:09

I am a newbie in PE and found that the "Group By" checkbox is checked sometimes when the operator is Index Seek or Index Scan. Is there any online help talks about the "Query Columns" tab?


Aaron Bertrand 2016-06-17 04:23:57
This tab is documented in the Plan Explorer User Guide, and I also talk about it briefly in my Plan Explorer Demo Kit, but I don't think either of those go into the level of detail you're looking for. I will look into whether we have anything more elaborate handy, and if not, will make a work item to produce something.
kamingbb 2016-06-17 04:14:46
Thank you Aaron. I finally understand it, it's nothing to do with the "Sort" operator. The "Group By" column checked because of the "Collapse", "Segment" or "Stream Aggregate" operator 🙂