ClickHouse useful references
1 https://github.com/ClickHouse/ClickHouse/issues/4796 [Use of LowCardinality and/or INDEX to speed up query performance]
2 https://altinity.com/blog/harnessing-the-power-of-clickhouse-arrays-part-1 [Harnessing the Power of ClickHouse Arrays – Part 1]
3 https://altinity.com/blog/harnessing-the-power-of-clickhouse-arrays-part-2 [Harnessing the Power of ClickHouse Arrays – Part 2]
4 https://altinity.com/blog/harnessing-the-power-of-clickhouse-arrays-part-3 [Harnessing the Power of ClickHouse Arrays – Part 3]
5 https://www.instana.com/blog/reducing-clickhouse-storage-cost-with-the-low-cardinality-type-lessons-from-an-instana-engineer [Reducing Clickhouse Storage Cost with the Low Cardinality Type – Lessons from an Instana Engineer]
6 https://kb.altinity.com/altinity-kb-schema-design/how-much-is-too-much/ [How much is too much?]
7 https://kb.altinity.com/engines/mergetree-table-engine-family/ [mergetree-table-engine-family]
8 https://kb.altinity.com/altinity-kb-setup-and-maintenance/altinity-kb-memory-configuration-settings/ [memory configuration settings]
9 https://blog.krybot.com/a?ID=01800-4033273b-b0e3-49e7-9e16-817615f0acba [Talk about the fixed/adaptive index granularity of ClickHouse MergeTree engine]
10 https://altinity.com/blog/clickhouse-black-magic-skipping-indices [ClickHouse Black Magic: Skipping Indices]
11 https://altinity.com/presentations/a-day-in-the-life-of-a-clickhouse-query-2 [A Day in the Life of a ClickHouse Query]
12 https://presentations.clickhouse.com/meetup53/optimizations/index.html [Tales About Performance Optimizations in ClickHouse]
13 https://presentations.clickhouse.com/meetup53/jit_in_clickhouse/index.html [jit_in_clickhouse]
14 https://presentations.clickhouse.com/bdtc_2019/ [The Secrets of ClickHouse Performance Optimizations]
15 https://blog.karatos.in/a?ID=01750-9488ce03-e456-4f5c-bcf3-d5fe717a66cd [Talking about SIMD, SSE instruction set and ClickHouse vectorized execution]
16 https://altinity.com/presentations/more-secrets-of-clickhouse-query-performance [MORE secrets of ClickHouse Query Performance]
17 https://clickhouse.com/company/events/query-performance-introspection
18 https://presentations.clickhouse.com/meetup20/performance_analysis/ [Performance Analysisof ClickHouse Queries]
19 https://clickhouse.com/blog/common-getting-started-issues-with-clickhouse
20 https://altinity.com/new-tips-and-tricks-that-every-clickhouse-developer-should-know
21 https://altinity.com/presentations/2019/7/31/introduction-to-the-mysteries-of-clickhouse-replication
22 https://kb.altinity.com/engines/mergetree-table-engine-family/part-naming-and-mvcc/ 【all altinity knowledge base】
23 https://clickhouse.com/blog/aggregate-functions-combinators-in-clickhouse-for-arrays-maps-and-states [Using Aggregate Combinators in ClickHouse]
24 https://github.com/ClickHouse/ClickHouse/issues/16595 [Easier ways to understand SimpleMergeSelector]
25 https://www.youtube.com/watch?v=mTUL7Jmk0T0 [ClickHouse Performance Master Class – Tools and Techniques to Speed up any ClickHouse App Webinar]
26 https://github.com/ClickHouse/ClickHouse/issues/22398 [A list of benchmarks]
27 https://www.tinybird.co/clickhouse/knowledge-base/
28 https://den-crane.github.io/Everything_you_should_know_about_materialized_views_commented.pdf
