View Join Report
You can view the details of joins between all the tables in a database.
On the Reports page, click the Join Report icon to view the Join reports for each database. You can change the database from the drop down list to view the join diagram for that database.
You can further refine your join diagram using join algorithms:
- Hash Join
- Merge Join
- Lateral View Join
- Sorted Merge
The diagram will be updated on the basis of your selection.