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 shardsLearn what table shards 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.