v.21.1Improvements

set indices now support GLOBAL IN functionality

Official CH changelog text
Now set indices will work with GLOBAL IN. This fixes #17232 , #5576 . #17253 (Amos Bird).
The set index feature in ClickHouse now supports usage with GLOBAL IN clauses.

Why it matters

This enhancement fixes issues where set indices did not function correctly with GLOBAL IN, improving query performance and index utilization when filtering with GLOBAL IN. It resolves reported problems documented in issues #17232 and #5576.

How to use it

Users can now seamlessly use set indices in their queries involving GLOBAL IN without any additional configuration. Simply write queries with WHERE column GLOBAL IN set_expression and benefit from optimized index usage.

Related resources

PreviousNext