ClickHouse has certain isolated cost-based optimization mechanics, such as: the order of reading columns is determined by the cost of reading compressed ranges of data from disk. ClickHouse also does JOIN reordering based on column statistics, however, this is (as of 2025) not nearly as advanced as CBE in Postgres, Oracle, MS SQL Server.Documentation Index
Fetch the complete documentation index at: https://private-7c7dfe99-test-mutation-observers.mintlify.app/llms.txt
Use this file to discover all available pages before exploring further.
Introducing Managed ClickStack: Observability for OpenTelemetry at scale Read more →
- What is a columnar database?
- Does ClickHouse support frequent, concurrent queries?
- Does ClickHouse have a cost-based optimizer
- Does ClickHouse support data lakes?
- What does "ClickHouse" mean?
- What are the 3rd-party dependencies for running ClickHouse?
- Does ClickHouse support distributed JOIN?
- Does ClickHouse support federated queries?
- How do I contribute code to ClickHouse?
- Why not use something like MapReduce?
- What does “не тормозит” mean?
- What is OLAP?
- What SQL syntax does ClickHouse support?
- Does ClickHouse support real-time updates?
- Who is using ClickHouse?
- Why is ClickHouse Keeper recommended over ZooKeeper?
Introducing Managed ClickStack: Observability for OpenTelemetry at scale Read more →
Does ClickHouse have a cost-based optimizer
ClickHouse has certain cost-based optimization mechanics
Was this page helpful?
Previous
Does ClickHouse support data lakes?ClickHouse supports data lakes, including Iceberg, Delta Lake, Apache Hudi, Apache Paimon, Hive
Next
⌘I