v.24.9Improvement

Index Analysis Optimization for Large Tables in ClickHouse

Index analysis can take noticeable time for big tables with many parts or partitions. This change should enable killing a heavy query at that stage. #69606 (Alexander Gololobov).
Enable cancellation of index analysis queries during execution for large tables with many parts or partitions.

Why it matters

Index analysis on big tables can be time-consuming, causing prolonged query execution. This feature allows users to kill heavy index analysis queries mid-execution, improving query management and resource control.

How to use it

Users can simply send a kill command to the running index analysis query as usual. The system now supports cancellation during the index analysis phase, allowing termination of the query before completion if it takes too long.