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

Report message to a moderator

Re: Tool [message #167573 is a reply to message #167571] Fri, 14 April 2006 01:16 Go to previous message
Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Previous Topic: Use of Histogram and Statistics for All Index columns or All columns?
Next Topic: sort unique problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 15:39:03 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.