In my case, the typical scenario is running aggregation and analytical functions over a small number of columns, while the number of rows is huge. The SQL synta

In my case, the typical scenario is running aggregation and analytical functions over a small number of columns, while the number of rows is huge. The SQL syntax is the same, but the columnar storage model better fits this case. A good illustration is available in ClickHouse documentation: https://clickhouse.tech/docs/en/#why-column-oriented-databases-work-better-in-the-olap-scenario https://clickhouse.tech/docs/en/#why-column-oriented-databas....