For a long time, the advice around FINAL in ClickHouse was pretty straightforward:


Avoid it whenever possible.


And honestly, that advice existed for good reasons.

Older versions of ClickHouse could make FINAL extremely expensive depending on:


table size
partitioning
number of parts
merge state
query patterns


So people started treating...