Clicking this button creates an Audit Joins job and displays it in the My Jobs dialog.
When the job completes, a View Results button is shown. Clicking it displays the Validate Joins – Results dialog.
A Joins Report is displayed therein, documenting the following:
•Missing tables
•Missing columns
•Data type mismatches
•Missing indexes (SQL Server only)
A Copy Results to Clipboard button is available at the bottom of the dialog.
Some pointers on interpreting the results of a joins audit:
•Missing table: recommended to delete the RPI join, thereby removing the orphan.
•Data type mismatch: even if the left & right joins are indexed, there is a high risk of implicit conversions, index scan and table scans. Recommended to ensure that columns on the right and left of joins are indexed and have same data type and length.
•No index found: highly likely to result in table scans. Recommended to ensure that columns on the right and left of joins are indexed and have same data type and length.