Tuning tool for SQL queries

[rbl]

Hopefully this question is acceptable for this forum but I need advice on a good SQL tuning tool that can recommend improvements to SQL statements to improve performance.
Unfortunately my favorite tool PL/SQL Developer does not cater for this. Cost is essential as I have seen excellent tools to the value of $4000.00 which is simply out of reach for smaller South African companies. Any recommendations?

 

[Marco Kalter]

There are several SQL and PL/SQL optimization features in PL/SQL Developer:
[*] You can use the built-in Explain Plan utility to examine query plans and optimize your SQL Statements.

[*] The Statistics Report in the SQL Window and Test Window will display any resource usage information (CPU, I/O, network traffic, ...) you are interested in, so that you can find the most optimal approach for your queries.

[*] The SQL Trace feature allows you to log all server processing (CPU, I/O, ...) caused by a SQL Window or Test Window in a trace file on the database server if the timed statistics parameter of the database instance you are using is set to true.

[*] The PL/SQL Profiler in the Test Window allows you to view the execution time of all SQL and PL/SQL code that was executed.[/list]

------------------
Marco Kalter
Allround Automations

[This message has been edited by mkalter (edited 06 February 2003).]