概述
这是 Alexey Milovidov(ClickHouse 的创建者)给出的关于复合主键的答案的翻译。
原文: https://groups.google.com/g/clickhouse/c/eUrsP30VtSU/m/p4-pxgdXAgAJ
问题:
-
主键可以有多少列?存储驱动器上的数据布局是什么?有任何理论/实践限制吗?
-
某些行缺少数据的列可以成为主键的一部分吗?
This is the translation of answer given by Alexey Milovidov (creator of ClickHouse) about composite primary key.
Questions:
1.How many columns primary key could have? And what is layout of data on storage drive? Is there any theoretical/practical limits?
2.Could columns with missing data at some rows be part of primary key?