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
邮箱：yuan.liu@esgyn.cn<mailto:yuan.liu@esgyn.cn>
[易鲸捷logo中文 - 副本]