As a user of Aiven for ClickHouse,
I want to use the most optimized default settings possible. From the start I want to have the default JOIN set as the most performant possible and not the ClickHouse default one. This comes without me, the user, having to change any settings. However, I should be able to tweak those settings if needed in specific cases.
See https://clickhouse.com/docs/en/engines/table-engines/special/join