wood burning stoves 2.0*
The moose likes JDBC and the fly likes DB Visualizer: query optimization Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB Visualizer: query optimization" Watch "DB Visualizer: query optimization" New topic
Author

DB Visualizer: query optimization

Gian Franco
blacksmith
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?

Thanks,

Gian


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

Joined: Feb 19, 2009
Posts: 25
Gian,

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:

http://www.dbvis.com/products/dbvis/doc/main/doc/ug/sqlCommander/sqlCommander.html#mozTocId979712

Best Regards

Roger
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB Visualizer: query optimization
 
Similar Threads
UML of the existing database
newbie to MySql how to visualize?
DB Visualizer: database refactoring
* Winners: DbVisualizer
JasperReports Question (Speed up report generation)