Set up docs MCPThese settings are available in system.settings and are autogenerated from source.
join_to_sort_maximum_table_rows
Experimental featureType
UInt64
Default
10000
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.9 | 10000 | The maximum number of rows in the right table to determine whether to rerange the right table by key in left or inner join |
The maximum number of rows in the right table to determine whether to rerange the right table by key in left or inner join.
join_to_sort_minimum_perkey_rows
Experimental featureType
UInt64
Default
40
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.9 | 40 | The lower limit of per-key average rows in the right table to determine whether to rerange the right table by key in left or inner join. This setting ensures that the optimization is not applied for sparse table keys |
The lower limit of per-key average rows in the right table to determine whether to rerange the right table by key in left or inner join. This setting ensures that the optimization is not applied for sparse table keys