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

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

Asked Jul 28, 2024 Modified Jan 1, 0001
Viewed 80
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
delete bitmap问题
1 answers
1.2.8升级2.0.0 报错
1 answers
Doris修改表分区
1 answers
doris数据存储是放在服务器磁盘上还是oss上面好?
1 answers
如何降低doris远程存储的访问频率
1 answers
3个并发任务写入同一张表,报错 get tableList write lock timeout
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 中文技术论坛.