This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes How can you tune SQL statements Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How can you tune SQL statements" Watch "How can you tune SQL statements" New topic
Author

How can you tune SQL statements

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Hi

Please tell me if there is any tool avialable that will tune SQL statements .


Save India From Corruption - Anna Hazare.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30068
    
149

Ravi Kiran V wrote:Hi

Please tell me if there is any tool avialable that will tune SQL statements .

Yes, but they tend to be database specific. The most common is the explain command.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can you tune SQL statements
 
Similar Threads
How to show hibernate sql parameter values, instead of ?,?
Queries within Queries within Queries...
How to trace SQL statements ?
PreparedStatement and CallableStatement?
Optimization