aspose file tools*
The moose likes JDBC 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
Bookmark "DB Visualizer Execution Plan" Watch "DB Visualizer Execution Plan" New topic
Author

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
Greenhorn

Joined: Feb 19, 2009
Posts: 25
Mark,

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

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

Note that this works only with the DbVisualizer Personal edition.

Regards

Roger
Mark Reyes
Ranch Hand

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

This feature is really cool...

Thanks for your reply...
 
 
subject: DB Visualizer Execution Plan