| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL Tuning
I have a suggestion for what I feel is the best SQL optimisation tool in the
market! It's a tool called SQLExpert from a company called Leccotech.
This tool uses a feedback engine which looks at the structure of the database, and then rewrites as many semantically equivalent statements as is possible - automatically - for you! You can then run these alternate statements through an automated process to determine which statement has either the best response or elapsed times. Then generate a lovely little report for the damagement!
The tool comes in either Developer or DBA editions, so you can have a developer looking at SQL from source, and developing new SQL, and the DBA gets an extra interactive module that looks at the SOLARIA and alike, and harvests "bad" SQL through criteria - PROCESS/USERNAME/HIGH BUFFER GETS etc..
Take a look at www.leccotech.com to learn more about it..
Also available through Cool-Tools :)
Mark
Mark Leith
P.S sorry about the plug..
Does anyone have any suggestion on a good SQL Tunning tool. Received on Fri Nov 03 2000 - 09:27:02 CST
 |
 |