Apache Doris 中文技术论坛
Questions Tags Users Badges

大量的left join导致查询慢,该如何优化啊?

Asked Jul 28, 2024 Modified Jan 1, 0001
Viewed 78
2.0

我把源库的表,同步到doris里面,doris查询略显耗时,该从什么方向入手优化啊?
image.png

edited Jan 1, 0001
____27
asked Jul 28, 2024
1 Answers

个人建议:LEFT JOIN (XXXXX WHERE XX=XX) 子表 ON 主表.关联条件=子表.关联条件 这样可以试试看

edited Jan 1, 1970
黑龙骑士13
answered Jul 29, 2024
Related Questions
doris数据存储是放在服务器磁盘上还是oss上面好?
1 answers
如何降低doris远程存储的访问频率
1 answers
3个并发任务写入同一张表,报错 get tableList write lock timeout
1 answers
Doris v2.0.10 Tablet 副本修复失败
1 answers
doris FE jdb文件损坏,应该如何修复,修复不了直接删除有什么影响?
1 answers
Doris V2.0.10 不支持直接调整表的压缩策略吗?
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.