GeeCON Prague 2014*
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


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
 
GeeCON Prague 2014
 
subject: DB Visualizer: query optimization