enable sort-merge join and JTC

enable sort-merge join and JTC enables or disables the query processor to select a sort merge or a nested loop join when SAP ASE compiles a query in compatibility mode.

Summary Information

Default value

0 (off)

Valid values

0 (off), 1 (on)

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Query Tuning

enable sort-merge join and JTC enables join transitive closure (JTC), which allows the query processor for releases earlier than 15.0 to use additional join clauses.

For more information about compatibility mode, see the Migration Technology Guide.