SQL Query Tuner 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:
• Changing Diagram Detail Display
• Interpreting the VST Diagram Graphics

Changing Diagram Detail Dispay

EXPANDING SUBQUERIES AND NESTED SUBQUERIES

Double-click queries to expand them or right-click the query and select Expand Query from the menu that appears. The following shows several layers of nesting queries.