Use toad for SQL Optimization

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

Executed SQL

 

Then current SQL will be executed and alternative SQL statement will be generated.

 

5. Compare result
 

From above using where clause replace having clause is fine.

Actually SQL tuning tools is derived from Quest SQL optimizer. If you learn more please go through http://www.quest.com/sql-optimizer-for-oracle/

Although SQL tuning optimizer help us a lot, Master SQL tuning we shoshould have deep understand such like SQL Execution Plan,
Auto trace statistics, table join, index and so on.

The demo is based on toad for Oracle 10.5.0.41

Author: Robinson Cheng

Blog: http://blog.csdn.net/robinson_0612