File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes DB Visualizer: query optimization Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "DB Visualizer: query optimization" Watch "DB Visualizer: query optimization" New topic

DB Visualizer: query optimization

Gian Franco
Ranch Hand

Joined: Dec 16, 2003
Posts: 977
Hi Roger,

Not daily, but only every now and then I encounter issues with regards to
the performance of SQL queries.

How does DB Visualizer support in the inspection or optimization of queries?



"Eppur si muove!"
Roger Bjärevall
DbVisualizer Support

Joined: Feb 19, 2009
Posts: 25

For Oracle, DB2 and SQL Server DbVisualizer have built-in support for presenting explain plan data in a more readable style . For other databases you can run the appropriate commands that will generate the plan data and see the result in DbVisualizer.

Read more about the explain plan support in:

Best Regards

I agree. Here's the link:
subject: DB Visualizer: query optimization
jQuery in Action, 3rd edition