Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: Build Queries Visually > Analyze Joins

Analyze Joins

Toad provides a tool to help you analyze and visualize joins. This feature is available in the Query Builder and the Database Diagram (ER Diagram) and allows you to profile data based on the relationship between tables.

After building a query in the Query Builder or a diagram in Database Diagram, simply click on a join to view a Venn diagram and a data grid. The Venn diagram allows you to visualize how values (rows) are distributed within the joined tables. The data grid displays the data represented by the selected segment of the Venn diagram.

To analyze joins

  1. Build a query in the Query Builder (or a diagram in the Database Diagram).
  2. Add or modify joins, as necessary. See Join Columns for more information.
  3. In your diagram, click on the join you want to analyze.
  4. The Analyze Join pane opens displaying the Venn diagram of the join. Click on a segment of the Venn diagram to display the data represented by that segment.
  5. If the join is a Cartesian join or if it is not a good relationship, this is indicated in the diagram.

Tips:

Considerations and Limitations of Analyze Join

Consideration/Limitation Description
Toad Views are not supported You cannot use Analyze Join with Toad Views.

  

Related Topics

of