Data Analytics Studio Operations
Also available as:

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 Reports > Join Report. 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:

  • Join
  • Hash Join
  • Merge Join
  • Lateral View Join
  • Sorted Merge

The diagram gets refreshed based on your selection.