See the docs: https://clickhouse.tech/docs/en/ https://clickhouse.tech/docs/en/ > Different orders for storing data are better suited to different scenarios. T

See the docs: https://clickhouse.tech/docs/en/ https://clickhouse.tech/docs/en/ > Different orders for storing data are better suited to different scenarios. The data access scenario refers to what queries are made, how often, and in what proportion; how much data is read for each type of query – rows, columns, and bytes; the relationship between reading and updating data; the working size of the data and how locally it is used; whether transactions are used, and how isolated they are; requirements for data replication and logical integrity; requirements for latency and throughput for each type of query, and so on.