Home » RDBMS Server » Performance Tuning » Tool
Tool [message #167571] Fri, 14 April 2006 00:50 Go to next message
goodsadanand
Messages: 4
Registered: April 2006
Junior Member
hi,

I am looking for a tool on the net(downloadable or online) ,
which can validate my sqls...in the sense that it can suggest me a better , more effecient way of writing my query...

Suggestions please
Re: Tool [message #167573 is a reply to message #167571] Fri, 14 April 2006 01:16 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> in the sense that it can suggest me a better , more effecient way of writing my query
This may not be exactly what you are looking into. Sometimes an SQL statement may be good or bad depending on data. The generic methods to write a better SQL are already discussed in performance guide under section SQL STATEMENT TUNING.

http://www.oracle.com/technology/oramag/oracle/04-may/o34tech_talking.html
Previous Topic: Use of Histogram and Statistics for All Index columns or All columns?
Next Topic: sort unique problem
Goto Forum:
  


Current Time: Wed May 29 19:27:55 CDT 2024