Enabling join transitive closure

A System Administrator can enable join transitive closure at the server level with the enable sort-merge joins and JTC configuration parameter. This configuration parameter also enables merge joins. At the session level, set jtc on enables join transitive closure, and takes precedence over the server-wide setting. For more information on the types of queries likely to benefit from the use of join transitive closure.

See “Enabling and disabling join transitive closure”.