Viewing the Join report
The Join report provides you the details of joins between all the tables in a database.
To view the join report, click. You can change the database from the dropdown list to view the join diagram for that database.
You can switch between the databases using the Database dropdown menu.
To refine your search based on time, select the time period from the dropdown. After you select the time period, the corresponding “to” and “from” dates representing the selection are displayed along with the time zone. The time zone that is displayed is that of the DAS server.
You can further refine your join diagram using the following join algorithms:
- Hash Join
- Merge Join
- Lateral View Join
- Sorted Merge
The diagram gets refreshed based on your selection.