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.