为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:Linux version 4.19.90-25.37.v2101.ky10.aarch64 (KYLINSOFT@localhost.localdomain)
【CPU】:
【问题描述】*:单表4千多万条数据,groupby语句如何优化
SELECT
"FTASKINFOID" AS "FTASKINFOID",
"FTYPE" AS "FTYPE",
"FPLACEOBJID" AS "FPLACEOBJID",
"FPERSONOBJID" AS "FPERSONOBJID",
"FCREATEUSERID" AS "FCREATEUSERID",
MAX("TCREATEDATE") AS "TCREATEDATE"
FROM
"T_DISTRIB_FORM_DETAIL"
WHERE
"FPARENTFORMINFOID" = 0
AND "FTASKINFOID" IN (2019, 2020, 2021)
GROUP BY
"FTASKINFOID",
"FTYPE",
"FPLACEOBJID",
"FPERSONOBJID",
"FCREATEUSERID"
建议发一下您的执行计划 以及这样表的ddl