3 ms·
ClickHouse performance is principally due to column storage, compression, and ability to parallelize processing. Arrays can improve performance in some specifi
by hodgesrm 6y ago
ClickHouse performance is principally due to column storage, compression, and ability to parallelize processing. Arrays can improve performance in some specific cases but are more commonly used to help deal with semi-structured data or perform custom processing on values within groups.
If your data maps cleanly to tables, that's in fact the best case with the easiest options for performance enhancement.