In a context, there are three STATES defined for a JOIN −

INCLUDED joins − In a part of the schema that is ambiguous, the context solves the loop by defining a path with the included joins.

Excluded joins − In a part of the schema that is ambiguous, the excluded joins define the path that context will never take.

Neutral joins are in a part of the schema that is not ambiguous, and are always included in the query path of the context. Any join that is not explicitly included or excluded is neutral.

A Context can be defined manually or by clicking DETECT Context option.

In a context, there are three states defined for a Join −

Included joins − In a part of the schema that is ambiguous, the context solves the loop by defining a path with the included joins.

Excluded joins − In a part of the schema that is ambiguous, the excluded joins define the path that context will never take.

Neutral joins are in a part of the schema that is not ambiguous, and are always included in the query path of the context. Any join that is not explicitly included or excluded is neutral.

A Context can be defined manually or by clicking detect Context option.