enable merge join enables or disables merge join at the server level.
|
Summary Information |
|
|---|---|
|
Default value |
2 |
|
Range of values |
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. |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Query Tuning |
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 |