trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liu, Yuan (Yuan)" <yuan....@esgyn.cn>
Subject How to get a sort_groupby plan
Date Sat, 13 Oct 2018 15:57:37 GMT
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中文 - 副本]

Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message