distributed_index_analysis
Index analysis will be distributed across replicas. Beneficial for shared storage and huge amount of data in cluster. Uses replicas from cluster_for_parallel_replicas. See also- distributed_index_analysis_for_non_shared_merge_tree
- distributed_index_analysis_min_parts_to_activate
- distributed_index_analysis_min_indexes_bytes_to_activate
distributed_index_analysis_for_non_shared_merge_tree
Enable distributed index analysis even for non SharedMergeTree (cloud only engine).distributed_index_analysis_only_on_coordinator
If enabled, distributed index analysis runs only on the coordinator. This prevents O(N^2) spawned queries when the predicate contains subqueries (e.g.,IN (SELECT ...)),
because each follower replica would otherwise independently trigger its own distributed index analysis,
but makes distributed index analysis less efficient if large tables are used in the subqueries.