使用哪个 Oracle SQL 查询优化工具？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6383762/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Which Oracle SQL query optimization tool to use?
提问by marinus
Yesterday I read an article in PowerTimes ( dec. 2002 :) ) about a great SQL Optimization tool called SQL Expert created by Leccotech. This company is probably taken over by Quest Software and I faced a lot of bugs in the trial version of Quest SQL Optimizer 8.0.0.
昨天我在 PowerTimes（2002 年 12 月 :) 上阅读了一篇关于 Leccotech 创建的名为 SQL Expert 的出色 SQL 优化工具的文章。这家公司可能被 Quest Software 接管，我在 Quest SQL Optimizer 8.0.0 的试用版中遇到了很多错误。
Which software do you prefer to optimize your Oracle ( 10 or 11 ) SQL queries?
您更喜欢使用哪种软件来优化您的 Oracle（10 或 11）SQL 查询？
Regards, Marinus
问候， 马里纳斯
回答by tbone
I too use explain plan (and a decent grasp on Oracle Conceptsand the optimizer), but I'll also mention that Oracle develops a SQL DeveloperIDE that is getting more advanced than when I first used it.
我也使用了解释计划（并且对Oracle 概念和优化器有很好的掌握），但我还要提到 Oracle 开发的SQL DeveloperIDE 比我第一次使用它时更先进。
SQL Developer now has a SQL tuning advisorthat is worth checking out. I have not yet used the latest version, but will be doing so soon.
SQL Developer 现在有一个值得一试的SQL 调优顾问。我还没有使用最新版本，但很快就会使用。
Hope it helps.
希望能帮助到你。
回答by a_horse_with_no_name
I use EXPLAIN PLAN with the SQL client of my choice
我将 EXPLAIN PLAN 与我选择的 SQL 客户端一起使用
回答by Joel Slowik
I also use the explain plan.
我也使用了解释计划。
The best method to tune a query is to know as much about what it's purpose is and what it is doing.
优化查询的最佳方法是尽可能多地了解查询的目的和用途。
Learn about the tables, indexes, constraints, data most importantly, and how the CBO (or RBO) is going to retrieve the data.
了解最重要的表、索引、约束、数据，以及 CBO（或 RBO）将如何检索数据。
You can use software to point and click your way through, but if you don't know yourself what the query and oracle is doing, you won't get very far.
您可以使用软件指向并单击您的方式，但是如果您不知道查询和 oracle 正在做什么，您将不会走得很远。
