Visual SQL Tuning is not available in DB Optimizer Developer. 

DB Optimizer can now parse an SQL query and analyze the indexes and constraints on the tables in the query and display the query in graphical format on The Visual SQL Tuning (VST) diagram, which can be displayed in either Summary Mode or Detail Mode. This helps developers, designers and DBAs see flaws in the schema design such as Cartesians joins, implied Cartesians joins and many-to-many relationships. The VST diagram also helps the user to more quickly understand the components of an SQL query, thus accelerating trouble- shooting and analysis. 

This section is comprised of the following topics:


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal