本文介绍了如何通过Toad工具进行SQL优化。主要步骤包括获取执行计划、启用自动跟踪、收集执行后的统计信息、调整SQL及比较结果。强调虽然工具如Quest SQL Optimizer提供了便利，但理解SQL执行计划、自动跟踪统计、表连接和索引等基础知识至关重要。示例基于Toad for Oracle 10.5.0.41，作者为Robinson Cheng。
It is very easy for us to implement sql tuning by toad. We need to do is just give complex sql statement to toad. The article
give you some examples to demonstrate how to tuning sql by toad for oracle.
1. Get execution plan
Editor --> Explain plan current SQL or CTRL + E
2. Get statistics/Auto Trace
Enable Auto Trace panel.
or you can right click and choose auto trace to enable it in SQL editor blank.
3. Get statistics after executed sql.
4. Tuning SQL
最低0.47元/天 解锁文章
扫一扫
1593
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
