ClickHouse version 25.10 introduces a variety of enhancements including 20 new features, 30 performance optimizations, and 103 bug fixes. Noteworthy improvements include join enhancements like lazy columns replication, which reduces CPU and memory usage by deferring data duplication until necessary, and the use of Bloom filters to expedite joins by pre-filtering data. The release also adds the capability to push down complex conditions in joins, thus optimizing data retrieval. Automatic column statistics for MergeTree tables enhance query performance by supporting global join reordering, and new SQL updates allow for greater flexibility with operations like IS NOT DISTINCT FROM, negative limits, and offsets. Furthermore, the QBit data type is introduced for vector embeddings, allowing for tunable search precision, and the Arrow Flight integration has been expanded for better server and client compatibility. Finally, late materialization of secondary indices provides options to defer index computation, which can be manually triggered when needed, thereby accelerating data ingestion and processing.