DB Visualizer Execution Plan

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...

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

Hi Sir,

This feature is really cool...

Thanks for your reply...