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 Execution Plan 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 Execution Plan" Watch "DB Visualizer Execution Plan" New topic

DB Visualizer Execution Plan

Mark Reyes
Ranch Hand

Joined: Jul 09, 2007
Posts: 426
Hi Sir,

I have this query, in the company where I am working, there are a lot of Database that is being used such as DB2, MSSQL, Oracle and for stand alone MySQL and Access.
Oftentimes we do cross query between different RDBMS. I want to know if DB Visualizer has some sort of Query Execution Plan where I will be able to know where the bottleneck in my query is so that I could apply the needed change? (Index, Temp Table etc..)

Looking forward to your reply...

Sean Clark ---> I love this place!!!
Me ------> I definitely love this place!!!
Roger Bjärevall
DbVisualizer Support

Joined: Feb 19, 2009
Posts: 25

DbVisualizer supports explain plan for Oracle, DB2 LUW and SQL Server. Check this for more information:

Note that this works only with the DbVisualizer Personal edition.


Mark Reyes
Ranch Hand

Joined: Jul 09, 2007
Posts: 426
Hi Sir,

This feature is really cool...

Thanks for your reply...
I agree. Here's the link:
subject: DB Visualizer Execution Plan
It's not a secret anymore!