Win a copy of Mesos in Action this week in the Cloud/Virtualizaton 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