CLICKHOUSE GETS LAZIER (AND FASTER): INTRODUCING LAZY MATERIALIZATION

Summary from the TLDR Web Dev newsletter

ClickHouse, a fast analytical database, has introduced a new optimization called "lazy materialization" to improve query performance. This technique delays reading column data until it's absolutely necessary, especially benefiting Top N queries with large datasets and LIMIT clauses. An example of lazy materialization showed a query being sped up from 219 seconds to 139 milliseconds without SQL changes.