This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
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

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
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
jQuery in Action, 3rd edition