Summary information |
|
|---|---|
Default value |
2 |
Range of values |
0 – 2 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
Query Tuning |
enable merge join enables or disables merge join at the server level. Setting enable merge join to:
0 – disables merge joins at the server level
1 – enables merge joins at the server level.
2 – sets merge joins to their default values at the server level
The default value for merge join depends on current value of the optimization goal configuration parameter:
Value for optimization goal |
Default value for merge join |
|---|---|
allrows_mix |
on |
allrows_dss |
on |
allrows_oltp |
off |
