Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

optimize_group_* session settings

These settings are available in system.settings and are autogenerated from source.

optimize_group_by_constant_keys

Type
Bool
Default
1
Version history
VersionDefault valueComment
23.91Optimize group by constant keys by default

Optimize GROUP BY when all keys in block are constant

optimize_group_by_function_keys

Type
Bool
Default
1

Eliminates functions of other keys in GROUP BY sectio

Navigation