🔧 SELECT FINAL and OPTIMIZE FINAL Are Not the Same Thing

One thing that confused me when I first started learning ClickHouse was the word FINAL.

Because eventually you'll come across both:



SELECT *
FROM events FINAL;






and:



OPTIMIZE TABLE events... [Weiterlesen]