This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB Visualizer: query optimization

 
Gian Franco
blacksmith
Ranch Hand
Posts: 979
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Roger Bjärevall
DbVisualizer Support
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic