SQL优化 | 达梦技术社区

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8.6
【操作系统】：
【CPU】:
【问题描述】*：
请帮忙优化一下，太慢了。
SELECT
count(0)
FROM
bjgh_dw.bjgh_dw_sb_sbb a
LEFT JOIN bjgh_dw.bjgh_dw_jf_jfb b ON a.SBUUID = b.SBUUID
LEFT JOIN bjgh_gl.bjgh_gl_qx_enterprise c ON a.SHXYDM = c.unite_social_code
LEFT JOIN bjgh_gl.bjgh_gl_qx_org_zh d ON c.union_id = d.ORG_ID
LEFT JOIN bjgh_gl.bjgh_gl_qx_org_zh e ON d.PARENT = e.ORG_ID
WHERE
a.SBZT != '1'
AND c.enabled = '1'
AND c.deleted = '0'
AND d.GHDZM LIKE CONCAT(( SELECT ghdzm FROM bjgh_gl.bjgh_gl_qx_org_zh WHERE org_id = 123 ), '%' )
AND c.NAME LIKE concat( '%', '物流', '%' )
ORDER BY
a.FKSSQQ DESC,
a.SHXYDM DESC;
执行计划是：
执行计划1.txt

回答 0

暂无回答