Skip to main content
Skip to main content
Edit this page

Core Concepts

In this section of the documentation, you will learn some of the core concepts of how ClickHouse works.

PageDescription
Table partsLearn what table parts are in ClickHouse.
Table partitionsLearn what table partitions are and what they are used for.
Table part mergesLearn what table part merges are and what they are used for.
Table shards and replicasLearn what table shards and replicas are and what they are used for.
Primary indexesA deep dive into ClickHouse indexing including how it differs from other DB systems, how ClickHouse builds and uses a table's spare primary index and what some of the best practices are for indexing in ClickHouse.
Architectural OverviewA concise academic overview of all components of the ClickHouse architecture, based on our VLDB 2024 scientific paper.