enable merge join

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