| Author |
DB Visualizer: query optimization
|
Gian Franco
blacksmith
Ranch Hand
Joined: Dec 16, 2003
Posts: 975
|
|
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
|
|
 |
|
|
subject: DB Visualizer: query optimization
|
|
|
0
