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
|Some data sources are not supported||The Analyze Join feature does not support the following data sources at this time: Google Analytics, Salesforce, Oracle BI Enterprise, Microsoft SQL Server Analysis Services, and OData.|
|Toad Views are not supported||You cannot use Analyze Join with Toad Views.|