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

上海易鲸捷信息技术有限公司

地址:上海市浦东新区金科路2889号长泰广场A603

手机:13671935540

邮箱:yuan.liu@esgyn.cn

易鲸捷logo中文 - 副本