Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

optimize_redundant_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

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

optimize_redundant_comparisons

Type
Bool
Default
1
Version history
VersionDefault valueComment
26.71New setting to detect conflicting and redundant comparison conditions on the same expression within AND chains.

Detect conflicting and redundant comparison conditions on the same expression within AND chains. For example, a < 1 AND a > 5 would be rewritten to false.

optimize_redundant_functions_in_order_by

Type
Bool
Default
1

Remove functions from ORDER BY if its argument is also in ORDER BY

Navigation