Hi trafodioneers, I am trying to get a sort_groupby query plan, but I always get hash_groupby plan. Do you have any idea about how to get a sort_groupby plan?
>>explain options 'f' select a.INDUSTRYPHY,sum(a.REGCAP) from DMA_ENTTYPE_STAT >>a group by 1 order by 2; LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- 3 . 4 root 2.50E+001 2 . 3 sort 2.50E+001 1 . 2 hash_groupby 2.50E+001 . . 1 trafodion_scan DMA_ENTTYPE_STAT 5.03E+00 Best regards 刘源（Yuan） 上海易鲸捷信息技术有限公司<http://www.esgyn.cn/> 地址：上海市浦东新区金科路2889号长泰广场A座603 手机：13671935540 邮箱：[email protected]<mailto:[email protected]> [易鲸捷logo中文 - 副本]
