Show TOC

Extended ChecksLocate this document in the navigation structure

Concept

If a query on a CompositeProvider returns an unexpected result, you can use various options in the edit screen of a CompositeProvider to analyze the join conditions. This means you can find out which provider/analytic index caused the unexpected result.

Join Fields Analysis

You can analyze this join condition by using the field context menu.

Join Fields Analysis (All Indexes)

Using Extended Checks, you can select the option Join Fields Analysis (All Indexes) and perform an analysis of all the individual fields.

Step-by-Step Provider Join Analysis

This is the most extensive check. Using Extended Checks, you can select the option Step-by-Step Provider Join Analysis and perform an analysis of all the join conditions of all the providers/indexes.

First the union results are displayed. From here you can jump to the results. If a result is zero, the join condition is analyzed further. No further checks are performed on left outer joins.

The rows are colour-coded to provide greater clarity:

  • Yellow: Join functions as a filter

  • Green: Join does not function as a filter (left outer)