Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

一般特复杂的sql,可能使用该工具带来便利的效果越明显,但是sql越复杂,优化查询效率就是更加头疼的问题了。要是能有个sql性能优化或是最优的解决工具,配合一起,那就更牛逼了 #13

Open
olysa opened this issue Jun 22, 2022 · 2 comments

Comments

@olysa
Copy link

olysa commented Jun 22, 2022

No description provided.

@schild
Copy link

schild commented Jul 8, 2022

这个项目想法挺好,说到底就是做了个工具,用于循环替代关键字符,之前动态查询pivot表经常会有类似的方式做,确实不错

@liyupi
Copy link
Owner

liyupi commented Jul 8, 2022

离线分析场景 SQL 执行慢一会儿问题不大,有时可以牺牲性能来降低理解成本。

另外调优是需要贴合实际场景的。简单的优化查询引擎本身就会帮你做的,但更多的还是要结合业务场景、表的数据量、表之间的关系去分析,缺失了这些信息,也只能给出通用的优化建议。。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants