v.21.6Performance Improvement
Exclude Unused Shard Values from IN Clause in Distributed Queries
Exclude values that does not belong to the shard from right part of IN section for distributed queries (underoptimize_skip_unused_shards_rewrite_in, enabled by default, since it still requiresoptimize_skip_unused_shards). #21511 (Azat Khuzhin).