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 |
Used when Adaptive Server is in compatibility mode. Once enabled, when Adaptive Server compiles a query in compatibility mode, enable sort-merge join and JTC allows the query processor to select a sort merge or a nested loop join. 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.
